Re: Delete from table taking time
Date: Thu, 26 Mar 2009 09:50:14 +0000 (UTC)
Message-ID: <gqfj4m$u3a$3_at_solani.org>
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
> command
> 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?
-- http://mgogala.freehostia.comReceived on Thu Mar 26 2009 - 04:50:14 CDT