Re: performance on select query
out put of explain
table | type| possible | keys | key | key_len| ref | rows|Extra
tbl1 | range | PRIMARY | id | NewIndex | 8 | NULL | 147491 | Using where; Using filesort
tbl2 |ref |tbl2id |tbl2id |5 | tbl1.id | 1 | Using where
i understand when doing a blank search it has to do a table scan and then sort it alphabetically. Is there any other way where the result can be sorted alphabetically with less time and then limit the result set to 10/20 records?
at the moment we are looking up with alphabet A, and this seems to be one that doesn't have any answers?
thanks
lucy
Subject
Views
Written By
Posted
2417
May 27, 2005 10:35AM
1480
May 27, 2005 12:29PM
Re: performance on select query
1457
May 27, 2005 02:18PM
1556
May 28, 2005 11:42AM
1460
May 29, 2005 06:48PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.