Just noted that you had use_hash(small1) in your
sample hint. This shouldn't be there - the hint
means 'use a hash join to get into ...', and in your
case you want small1 to be the driving table.
--
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Next Seminar - UK, April 3rd - 5th
http://www.jlcomp.demon.co.uk/seminar.html
Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Author of:
Practical Oracle 8i: Building Efficient Databases
Jonathan Lewis wrote in message
<1017730837.2032.0.nnrp-08.9e984b29_at_news.demon.co.uk>...
>
>The plan you guessed at below is the
>one you are looking for, but the table
>order in the from clause would have to be:
>
>small1,
>big,
>small2
>small3
>small4
>small5
>
Received on Tue Apr 02 2002 - 01:11:12 CST
