RE: ** ordered use_nl question
- From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
- To: ajoshi977@xxxxxxxxx
- Date: Mon, 19 Jun 2006 12:03:15 -0700
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@xxxxxxxxx>:
> 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@xxxxxxxxxxx> 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
> On Behalf Of A Joshi
> Sent: Monday, June 19, 2006 8:37 AM
> To: oracle-l@xxxxxxxxxxxxx
> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
