Re: USE_NL with or without ORDERED

thanks for the explanation. I think you
are right in general, but do you think
it's a little out of logic. I have two tables
'a' and 'b'. If I point
the table 'b' as an inner table for N-L join
with the hint USE_NL(b), what is
the table 'a'? Wouldn't it be a driving table
in *N-L* ?

Here is a good excerpt from Development on hints and the
CBO... Query hints are used to restrict the number of
alternative execution plans the optimizer has to choose from. The optimizer
will still pick the cheapest plan from all of the alternatives considered. So
for example, you could get a situation where the optimizer picks a

plan which does not contain a nested-loops join even though
your query specified a USE_NL() hint. However, by
combining hints you can restrict the optimizers search
space to a single plan if you wish. For example the
query select /*+ ordered use_nl(b) */ a.x from a, b
where a.y = b.y; will only consider the plan "a NL b"
because the combination of hints limits the search
space to this single alternative. So if you have a <FONT
size=2>query for which you want to fix the execution plan, you may need to
use a combination of hints to restrict the search
space to a single possibility. <FONT

did anybody notice that sometimes CBO ignores USE_NL hint
without ORDERED
The following example was taken from oracle docs:
SQL> SQL> <FONT
size=2>SQL> select name, value 2 from
v$parameter 3 where name =
'optimizer_mode';
NAME <FONT

To REMOVE yourself from this mailing list, send an E-Mail
message to: ListGuru_at_fatcity.com (note EXACT spelling
of 'ListGuru') and in the message BODY, include a line
containing: UNSUB ORACLE-L (or the name of mailing
list you want to be removed from). You may also
send the HELP command for other information (like subscribing).
<FONT

email and any attachments may be confidential and the subject oflegal
professional privilege. Any disclosure, use, storage or copyingof this
email without the consent of the sender is strictly prohibited.Please
notify the sender immediately if you are not the intendedrecipient and
then delete the email from your inbox and do notdisclose the contents to
another person, use, copy or store theinformation in any