Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Cursor Performance -- How to Optimize?
Thanks -- that did it!
Alan
"Ulrik Hoffmann" <ulrik_at_hoffmann-kiel.de##nospam> wrote in message
news:879r1s$34oao$1_at_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.
>
>
>
>
Received on Wed Feb 02 2000 - 13:13:39 CST