Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: INSERT...SELECT...FROM TABLE(object-collection) slow
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
-- @home.com is bogus. Oprah, Oprah, Oprah Oprah http://www.signonsandiego.com/uniontrib/20060216/news_7m16visit.htmlReceived on Thu Feb 16 2006 - 18:25:30 CST