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

Hi,

we (sorrily) found out, that a

INSERT INTO <destination_table>
SELECT <attributes>
FROM TABLE (collection of object type)

is rather slow. When recoding the logic with PL/SQL-tables, many loops and FORALL INSERTs, we got performance gains of around 200x.

Any similar observations?

Any explanations?

Thanks in advance

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