Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Hint for using a nested loop for an in subquery
I have used a hint in the past to force a query to use a nested loop join
for a sub query however the name of the hint escapes me. I have googled for
it unsuccessfully. Anyone remember it offhand?
Query looks like
Select something
From table1
Where somethingelse in (select somethingelse from table2 where
somethingelse2 between x and y)
The ideal plan would evaluate the subquery first then use nested loops against an index belonging to table1. I have tried using the no_unnest, various index and use_nl hints unsuccessfully.
Thanks,
Ken
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Nov 03 2006 - 14:10:07 CST
![]() |
![]() |