Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: INSERT...SELECT...FROM TABLE(object-collection) slow
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