Re: Insert-Select much slower than same select on its own

zzzzzz45_at_hotmail.com wrote:
> Hi,
>
> I'm doing an insert into a table like so:
>
> Insert into table
> (field1, field2...)
> Select value1, value2...
> from view
>
> The select on its own runs in under a second. The insert select takes
> ~50 seconds. The explain plans differ greatly. The stats on the tables
> are up-to-date.
>
> I've tried the all_rows and append hints to no avail.
>
> Can somebody please advise why this drastic deterioration in
> performance may be happening?
>
> The db version is Oracle9i Enterprise Edition Release 9.2.0.6.0 -
> Production
>
> Thanks,
> Mark

how many rows do you select?
does it take under a second second to fetch all the rows? and are there any indexes on the target table? Received on Thu Aug 31 2006 - 08:53:20 CDT