Re: Deletion of Records

From: Hans Forbrich <forbrich_at_telusplanet.net>
Date: Wed, 23 Apr 2003 02:49:31 GMT
Message-ID: <3EA5FE1C.28A8D82B@telusplanet.net>

priya wrote:

> I have a table under Oracle 9i 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.

Have you tried dropping/disabling one or more indexes and recreating them after delete? It sounds like you do this 'clean up' occasionally, so you could do a timing comparison.

Is the selection criteria partitionable? If this is truly critical, you have the enterprise edition, and you can build partitions around the criteria, consider purchasing the partitioning option.

/Hans Received on Tue Apr 22 2003 - 21:49:31 CDT