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
3477
November 01, 2005 01:26AM
2274
November 01, 2005 02:48AM
Re: Simple Query - but explain worries me
2292
November 01, 2005 03:05AM
2153
November 01, 2005 05:13AM
2253
November 01, 2005 05:57AM
2190
November 01, 2005 07:37AM
2258
November 01, 2005 08:03AM
2201
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.