Re: Slow deleting records

drop index before delete

Scott yu Oracle DBA

Kevin P. Fleming wrote in message ...
>>I have a table that only has 15000+ records but when I try to delete all
 the
>>records it takes forever. We benched marked it to about 15 minutes per
 1000
>>records. The only thing I can think that may cause this is that this
 table
>>has a long datatype field but most records are very small.
>>
>>Any ideas would be appreciated.
>>
>>
>
>If you really want to delete _ALL_ the records, use the TRUNCATE command.
>It's instant, and can recover the storage allocated to the table as well if
>you like.
>
Received on Fri Nov 06 1998 - 00:00:00 CST