Re: Slow deleting records
From: Scott Yu <Scott.Yu_at_IPS-Sendero.com>
Date: 1998/11/06
Message-ID: <JvH02.193$0x2.2523147_at_news.goodnet.com>#1/1
Date: 1998/11/06
Message-ID: <JvH02.193$0x2.2523147_at_news.goodnet.com>#1/1
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 CET