Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: INSERT...SELECT...FROM TABLE(object-collection) slow

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

From: Joel Garry <joel-garry_at_home.com>
Date: 16 Feb 2006 16:25:30 -0800
Message-ID: <1140135930.784228.178860@g47g2000cwa.googlegroups.com>


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.html
Received on Thu Feb 16 2006 - 18:25:30 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US