MySQL Forums
Forum List  »  Performance

Re: select over big tables
Posted by: Mathieu Pichon
Date: January 21, 2005 08:04AM

find out which index is used with the EXPLAIN command

what is the more efficient to restrict your data set between ( you can only use one index at a time )
- tab2.id_code IN(2819,2813,5321,5329 )
- tab1.state IN ("ACT","NSW","NT","QLD","TAS","VIC" ))
- tab2.code ="A"

then force proper index usage

Options: ReplyQuote


Subject
Views
Written By
Posted
2903
January 12, 2005 12:57AM
Re: select over big tables
1772
January 21, 2005 08:04AM


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.