Xref: alice comp.databases.oracle.server:83094
Path: alice!news-feed.fnsi.net!news.idt.net!newsfeed.mathworks.com!newsfeed1.earthlink.net!nntp.earthlink.net!newsread1.prod.itd.earthlink.net.POSTED!not-for-mail
From: "Alan Fusco" <alanfusco@earthlink.net>
Newsgroups: comp.databases.oracle.server
References: <i%Zl4.696$Gi4.24897@newsread1.prod.itd.earthlink.net> <879r1s$34oao$1@fu-berlin.de>
Subject: Re: Oracle Cursor Performance -- How to Optimize?
Lines: 46
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
Message-ID: <Dl%l4.874$Gi4.28780@newsread1.prod.itd.earthlink.net>
X-Complaints-To: abuse@earthlink.net
X-Trace: newsread1.prod.itd.earthlink.net 949518819 158.252.112.23 (Wed, 02 Feb 2000 11:13:39 PST)
NNTP-Posting-Date: Wed, 02 Feb 2000 11:13:39 PST
Organization: EarthLink Network, Inc.
X-ELN-Date: Wed Feb  2 11:13:39 2000
Date: Wed, 02 Feb 2000 19:13:39 GMT

Thanks -- that did it!

Alan

"Ulrik Hoffmann" <ulrik@hoffmann-kiel.de##nospam> wrote in message
news:879r1s$34oao$1@fu-berlin.de...
> Hi Alan,
>
> you'll probably need  a blank after the + in the hint.
> This seems to be an oracle bug discussed some
> threads ago. The optimizer will convert it to
>
>  SELECT /*+LL_ROWS*/
>
> If you write it with a blank, it should work.
>
> Hth,
>
> Ulrik
>
>
> > When a return the results using a cursor:
> >
> > OPEN AUDIO_CV FOR
> > SELECT /*+ALL_ROWS*/
> >   A.field1,
> >   A.field 2,
> >   B.field 3,
> >   etc.
> > FROM
> >   TABLE A,
> >   TABLE B,
> >   etc.
> > WHERE
> >   table joins
> >
> >
> > It takes forever  -- as if the optimizer hint was ignored, which it
> probably
> > is.
>
>
>
>