Xref: alice comp.databases.oracle.server:83086
Path: alice!news-feed.fnsi.net!newsfeed.icl.net!bignews.mediaways.net!fu-berlin.de!uni-berlin.de!p3e9bfc53.dip0.t-ipconnect.DE!not-for-mail
From: "Ulrik Hoffmann" <ulrik@hoffmann-kiel.de##nospam>
Newsgroups: comp.databases.oracle.server
Subject: Re: Oracle Cursor Performance -- How to Optimize?
Date: Wed, 2 Feb 2000 18:53:40 +0100
Lines: 38
Message-ID: <879r1s$34oao$1@fu-berlin.de>
References: <i%Zl4.696$Gi4.24897@newsread1.prod.itd.earthlink.net>
X-Trace: fu-berlin.de 949514108 3301720 62.155.252.83 (16 [13717])
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300

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.