Re: INSERT...SELECT...FROM TABLE(object-collection) slow

On 16 Feb 2006 16:25:30 -0800, "Joel Garry" <joel-garry_at_home.com> wrote:

>Did you try an append hint?
>
>Really, the only explanation will come from tracing. We can't even
>guess from the description provided, except maybe to speculate your
>select was not as selective as your loops, or if it was more than just
>a simple select, recursively full-table-scanned.
>
>Did you try a CTAS instead of the insert? Did you get any plans?
>
>jg

(grrr...google.groups did some tricks with me)

No, No, it is really that simple!

Application throws data into a PL/SQL-package, we do come computations and then throw the data into one table using die FROM TABLE (collection) clause. No other table involved, no selectiveness, no explain plan, no table scans, no nothing, just "put this data there in!".

We observed, that getting data out of an object collection takes inappropriately long time. Is there anyone making similar observations? Is there someone out there who knows a little bit 'bout the internals of PL/SQL-objects?

BTW: use of APPEND-hint is no good, as it prevents from recoverability and writes above the HWM.

--
Marc Blum
mailto:blumXXXSPAMXXX_at_marcblum.de
http://www.marcblum.de