Re: SQL Hints

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Wed, 24 Mar 2004 14:49:14 +0100
Message-ID: <40619297$0$18764$636a15ce@news.free.fr>

"Marek Babski" <user72_at_go2.pl> a écrit dans le message de news:11d263ba.0403240532.63dd35e4_at_posting.google.com...
> I am preparing myself to talk for a new job. I have a question about SQL hints.
> In the only documentation I can find about it I see:
>
> select /*+ ordered use_hash (emp, dept) use_nl (sal, bon) */
> from emp, dept, sal,bon where . . .
>
> 1) Can anyone explain me in example what use_hash (emp, dept) is
> 2) what is the difference in use_hash (emp, dept) and use_hash (dept, emp)
> - please explain in example
> 3) use_nl (nested loop - what it is in example)
>
> Sincerly yours

Oracle version?

Have a look at:
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96533/hintsref.htm#8326

Regards
Michel Cadot Received on Wed Mar 24 2004 - 07:49:14 CST