Re: select over big tables
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
Subject
Views
Written By
Posted
3038
January 12, 2005 12:57AM
Re: select over big tables
1839
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.