Re: Simple Query - but explain worries me
Hi
just an thought, as the SQL optimizer is heavy voodoo stuff (and what I thing might simply not apply)
How about if the a.race_id > 300000 are fewer comparing a) to the a.race_id < 400000 and b) to b.race_id (with value >300000).
Then it would make sense to check the big table first (knowing that from statistics)
Subject
Views
Written By
Posted
3276
November 01, 2005 01:26AM
2201
November 01, 2005 02:48AM
Re: Simple Query - but explain worries me
2189
November 01, 2005 03:05AM
2073
November 01, 2005 05:13AM
2171
November 01, 2005 05:57AM
2128
November 01, 2005 07:37AM
2179
November 01, 2005 08:03AM
2132
January 02, 2006 05:22PM
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.