Re: Deletion of Records

From: Roger Jackson <rjackson1_at_hotkey.net.au>
Date: Tue, 22 Apr 2003 21:24:00 +1000
Message-ID: <3ea52652_1@news.iprimus.com.au>

Priya,

I had the same problem a few months back.

I found that CREATE TABLE AS SELECT with nologging and parallelism to create a new table containing the rows you want to keep was the best way. Once the new table was created drop the old table, rename the new one and build the indexes in parallel with nologging.

If the table is to grow to such as large size in the future you may want to consider using partitions.

HTH Roger.

"priya" <priya_at_informatic.com> wrote in message news:b83687$dds3_at_news.emirates.net.ae...
> I have a table with 20 million records. I have one primary and 4 secondary
> indexes. If i try to delete certain records (80%) of the records. It takes
> days to delete. How to do it fast.
>
> Your help in this regard is appreciated.
>
> Thanks
>
>
Received on Tue Apr 22 2003 - 06:24:00 CDT