Re: Simple Query - but explain worries me
Posted by:
Jake Day
Date: November 01, 2005 08:03AM
Vangelis,
I've just been reading up....whilst it still worries me that the optimiser gets something wrong that to me seems quite straightforward, there is an option i can use.
Select STRAIGHT_JOIN * from raceheader a, racedetail b where a.race_id = b.race_id
STRAIGHT_JOIN seems to force the optimiser to be ignored.......
Helps a little bit......
now if i can only get my "subqueries" to run before my main query i'll be a happy bunny.
Thanks for your help today.
Subject
Views
Written By
Posted
3447
November 01, 2005 01:26AM
2267
November 01, 2005 02:48AM
2281
November 01, 2005 03:05AM
2141
November 01, 2005 05:13AM
2235
November 01, 2005 05:57AM
2179
November 01, 2005 07:37AM
Re: Simple Query - but explain worries me
2244
November 01, 2005 08:03AM
2191
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.