Re: Deletion of Records

Some ideas:

• Are there any delete triggers defined for the table ?
• Any referential integrities which have to be checked before deleting data?
• Any snapshots which are refreshed automatically upon deleting data?
• Also, if you are posting a lot of single DELETE statements, it might help to check constraints at the final commit only:

setting for a single constraint:
SET CONSTRAINT xxxx DEFERRED

or for all constraints:
SET CONSTRAINTS ALL DEFERRED after committing, set back:
SET CONSTRAINTS ALL IMMEDIATE

--
Georg Scholz
www.scholz-informatik.at

"priya" <priya_at_informatic.com> schrieb im Newsbeitrag
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

>

>