Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Does the USE_NL hint really work?

Does the USE_NL hint really work?

From: Keith D Gregory <keith_at_inconcert.com>
Date: 1998/01/23
Message-ID: <34C8FF4A.941A47D4@inconcert.com>#1/1 







In some of the queries that I've been optimizing lately, I tried to use
the USE_NL hint rather than an INDEX( table primary_key ) hint. As far
as I can tell from the resulting explains, USE_NL really means "do
anything other than nested loops, giving preference to cartesion joins."



Has anyone else experienced this behavior?



-kdg
Received on Fri Jan 23 1998 - 00:00:00 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US