Re: Deletion of Records

priya wrote:
> 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.

Hello Priya,
one option is to dump out the rows to keep into a flat file, truncate the table and then load the flat file back into the database using SQL*Loader with direct path.

Hope that helps,
Lothar

-- 
Lothar Armbrüster       | la_at_oktagramm.de
Hauptstr. 26            | la_at_heptagramm.de
D-65346 Eltville        | lothar.armbruester_at_t-online.de