Re: Delete from table taking time
Date: Thu, 26 Mar 2009 09:50:14 +0000 (UTC)
On Thu, 26 Mar 2009 01:13:00 -0700, vipin.singla wrote:
> Hi Gurus
> I am having a problem of slowness in deleting the data from a global
> temporary table.
> The scenario is like
> I have a global temporary table which is populates in a procedure. The
> no of rows populated are approximately 0.5 million and its going to
> increase in future. The population of the table is done using the query
> Insert into TempTable Select xyz from permanenttable where xyz = 'abc'
> Now real problem comes when i want to empty the temporary table using
> Delete from TempTable; in the procedure.
> It takes about 50-60 seconds to execute.
> I have tried with truncate also which is taking less than 1 sec. But I
> can't use truncate as it is auto commit statement.
> Any comments on this?
What is your session waiting on?Received on Thu Mar 26 2009 - 04:50:14 CDT