Precisely govern an entire explain plan

From: Spendius <spendius_at_muchomail.com>
Date: 1 Dec 2005 05:03:11 -0800
Message-ID: <1133439896.538212.307460@g49g2000cwa.googlegroups.com>

Hello,
Is there a way to tell the optimizer to precisely follow the exact plan & access paths you want ? You can't specify a hint to join a result set to a table, then the result set this join will yield with another table etc., so how can you deal with this ?

If I have
SELECT...
FROM tab1, tab2, tab3, tab4

WHERE tab1.id = tab3.id
AND   tab3.id = tab2.id
AND   tab2.id = tab4.id

AND <filter clauses>;

How could I force the optimizer to first join TAB1 and TAB3 with a nested loop, then join this result to TAB2 using a hash etc etc. ??

Thanks so much, and regards.
Spendius Received on Thu Dec 01 2005 - 07:03:11 CST