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
3466
November 01, 2005 01:26AM
2272
November 01, 2005 02:48AM
Re: Simple Query - but explain worries me
2286
November 01, 2005 03:05AM
2149
November 01, 2005 05:13AM
2244
November 01, 2005 05:57AM
2188
November 01, 2005 07:37AM
2252
November 01, 2005 08:03AM
2197
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.