Re: Index Maintenance Vs Insert Response Time

From: Antony Raj <>
Date: Tue, 7 Feb 2012 08:17:01 -0800 (PST)
Message-ID: <>


It's an Insert .... select.
The select part is spending exactly the same amount of time(13 secs) from the extended trace.

Rows  Operation

0  LOAD TABLE CONVENTIONAL (crC1112 pr4448 pw=0 time11385671 us) 43,564     FILTER (crB7284 prD8 pw=0 time572425 us)


From: Sidney Chen <> To:
Cc: "" <> Sent: Tuesday, February 7, 2012 11:05 AM Subject: Re: Index Maintenance Vs Insert Response Time

Hi Antony,
Have you enabled entended sql trace to check the what's the major component of the current 6-7 minutes. Unless identifying what's responsible for the response time, we can only guess.

what's the method to insert the rows, are inserted in a single statment, in by inserting 45,000 times, in such a case,  you may want to try the array insert method, the forall statment.

Sidney Chen

Received on Tue Feb 07 2012 - 10:17:01 CST

Original text of this message