impact of deleting very huge amount of data on DB performance
961980Sep 13 2012 — edited Sep 14 2012Dears,
I have a table holding more than 250 Million records in a production server , and we are creating a tool to delete Millions number of records periodically .
the questions are:
1.after each run ,is the DB engine is going to delete the records physically or it is going to mark the rows inside the data block as deleted ?
2.if the answer of previous question is (records marked only in Data block and remains physically),
a. is it possible to enforce the DB engine to remove it physically ?
b. does rebuilding the index and analyzing the table will help ?
c. row migration will be considered in this operation , or it is only considered while issuing insert/update after delete?
3.if the answer id yes , records are removed physically , do I need to analyze the table and/or compress/reclaim tablespace ?
Regards
Edited by: 958977 on Sep 13, 2012 8:07 AM