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: <marc.blum_at_soptim.de>
Date: 17 Feb 2006 02:45:23 -0800
Message-ID: <1140173123.583837.179860@g14g2000cwa.googlegroups.com>

Joel Garry 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
> --
> @home.com is bogus.
> Oprah, Oprah, Oprah Oprah
> http://www.signonsandiego.com/uniontrib/20060216/news_7m16visit.html
Received on Fri Feb 17 2006 - 04:45:23 CST

Original text of this message

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