The syntax is still not right. Read the documentation (as I did): No comma in
the list within the use_nl hint. Also, according to the documentation, the table
(s) listed in the hint "is the name or alias of a table to be used as the inner
table of a nested loops join". I know that a list is legal, I just don't know
what that is supposed to mean in terms of being the inner table in an NL join.
I always use a single alias in the use_nl hint, except I hardly use such hints
at all. If the selectivity of the predicate used to select the driving table in
the current plan, maybe a better approach would be to collect a histogram so
that the optimizer "knows" that.


Quoting A Joshi <ajoshi977@(protected)>:

> Allen,
>    Yes. I am giving /*+ ordered use_nl  in the query.
>  I did not type properly in the e-mail below. so it is
>  
>  /*+ ordered use_nl(a,b,c,d) index(a emp_id) */
>  
>  Sorry. And thanks for your help.
>
>  
> "Allen, Brandon" <Brandon.Allen@(protected):
>     That syntax doesn't look right to me - I think it should be "ordered
> use_nl(a,b,c,d)" (not ordered_nl)
>
>  
> ---------------------------------
>  From: oracle-l-bounce@(protected)]
> On Behalf Of A Joshi
> Sent: Monday, June 19, 2006 8:37 AM
> To: oracle-l@(protected)
> Subject: ** ordered use_nl question
>
>  
>  select /*+ ordered_nl(a,b,c,d) index(a emp_id) */
>  but it does not seem to work.
>  
>  The plan does seem to change a little so the hint is having affect. However
> I am not able to get the desired plan. Any suggestions? Thanks for help
>  
>  Privileged/Confidential Information may be contained in this message or
> attachments hereto. Please advise immediately if you or your employer do not
> consent to Internet email for messages of this kind. Opinions, conclusions
> and other information in this message that do not relate to the official
> business of this company shall be understood as neither given nor endorsed by
> it.
>
>
>    
> ---------------------------------
> Do you Yahoo!?
> Get on board. You're invited to try the new Yahoo! Mail Beta.


--
regards

Wolfgang Breitling
Oracle 7,8,8i,9i OCP DBA
Centrex Consulting Corporation
www.centrexcc.com

--
http://www.freelists.org/webpage/oracle-l