RE: ** ordered use_nl question

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_at_yahoo.com>:

> 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_at_OneNeck.com> wrote:
> 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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of A Joshi
> Sent: Monday, June 19, 2006 8:37 AM
> To: oracle-l_at_freelists.org
> 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