Re: Optimizer hints in PL/SQL's embedded SQL

From: VSE <vsmeu_at_yahoo.fr>
Date: Tue, 29 Oct 2002 11:02:28 +0100
Message-ID: <aplll7$3m5$1@reader1.imaginet.fr>

Hi :)

I 'm not sure but I think that "hints" syntaxe is ( your example ) :

SELECT /* +INDEX(E) */ E.Id INTO AId FROM DocSpec E, .....

Is not :
SELECT /*+INDEX(E)*/ E.Id INTO AId FROM DocSpec E, .....

So /* toto */ not /*toto*/

Scuze me for my english :)

Regards ;)

Victor

"Sergey Balter" <balter_at_kompas.donetsk.ua> a écrit dans le message news: aplh8f$16nl$1_at_dipt.donbass.net...
> Hi, All,
>
> When I write something like
>
> procedure test is
> AId Integer;
> begin
> SELECT /*+INDEX(E) */
> E.Id INTO AId
> FROM DocSpec E, .....
> .........
> end;
>
> SQL Engine absolutely ignores hint /*+INDEX(E)*/
> Maybe PL/SQL quesses it's comments :-(((
>
> I am forced to bypass the problem using EXECUTE IMMEDIATE
>
> Is it the unique way? Does anybody know about specifying optimizer
> hint in in PL/SQL's embedded SQL?
>
> Regards,
> Sergey Balter
>
>
>
Received on Tue Oct 29 2002 - 04:02:28 CST