Originally posted by Priya
> 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.
>
> Your help in this regard is appreciated.
>
> Thanks
Probably better to create a new table by selecting the 20% you want to
keep, then drop the old table, rename the new, and add back the indexes
and constraints.
--
Posted via http://dbforums.com
Received on Tue Apr 22 2003 - 06:53:24 CDT
