Re: Deletion of records
From: TC <donotuse_at_donotuse.com>
Date: Tue, 22 Apr 2003 15:48:29 GMT
Message-ID: <hvdpa.568277$L1.166589_at_sccrnsc02>
Date: Tue, 22 Apr 2003 15:48:29 GMT
Message-ID: <hvdpa.568277$L1.166589_at_sccrnsc02>
I would drop the indexes, delete the records and recreate the indexes
//tc
"priya" <priya_at_informatic.com> wrote in message
news:b836ia$de05_at_news.emirates.net.ae...
> 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
>
>
>
>
Received on Tue Apr 22 2003 - 17:48:29 CEST