Re: Unexplained Performance Nightmare !!! Suggestions/solutions Please!!

From: Nuno Souto <nsouto_at_optushome.com.au.nospam>
Date: Sat, 28 Dec 2002 17:32:12 +1100
Message-ID: <3e0d486d$0$7817$afc38c87@news.optusnet.com.au>

27 Dec 2002 16:36:37 -0800, Dr Deadpan said (and I quote):

> INSERT INTO SELECT /*+ ORDERED */
> col1, col2,SUM(col3)...
>

IIRC, there was something about hints in embedded SQL in PL/SQL? They were ignored as comments by PL/SQL itself before being sent to the SQL engine?

Could well be the problem here. You might have to fire the statement via dynamic SQL rather than inline. Then the comment will be passed to the SQL engine.

-- 
Cheers
Nuno Souto
nsouto_at_optusnet.com.au.nospam

Received on Sat Dec 28 2002 - 00:32:12 CST