Re: Oracle Cursor Performance -- How to Optimize?

From: Ulrik Hoffmann <ulrik_at_hoffmann-kiel.de##nospam>
Date: Wed, 2 Feb 2000 18:53:40 +0100
Message-ID: <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.
Received on Wed Feb 02 2000 - 11:53:40 CST