Re: Not the same in SQL+ and in a function.

Oliver,

Don't know about optimizer-changes, never heard off, never experianced. What I did come across, is that grants in PL/SQL are NOT THE SAME as in SQL*Plus. This goes for grants got via a database role. Check that out.

sUCCes,
André

Olivier wrote:

> Hello,
> I have the following problem :
> I run an 'INSERT INTO xxx SELECT /*+RULE */ a,b,c,d FROM ....' to insert
> rows in a table, it works well in SQL+ but when I put the inert statement in
> a function it never finishes (I stopped it after 30 minutes), the database
> default optimizer mode is CHOOSE but it’s much slower than the RULE for this
> select statement. Does the function disable the HINT ? Is it another
> problem ?
> Thanks for your help.
> Olivier.
Received on Thu Aug 24 2000 - 13:57:39 CDT