Thank you for the details, experience shared and the suggestions.
Apologies for the delay in collecting the response for the queries.
(1)Are the tables tied together by FK?
- Overall there are 9 tables (sorry not 6 as mentioned originally) that are being purged. Only 4 tables would be having FK relationship.
(2)How big are the rows?
- The 9 tables now occupy almost 2TB space. Below is the rowsize (in bytes) and record-count details -
236 188,055,675
297 296,941,261
371 58,673,649
95 57,477,553
904 296,743,680
234 188,161,891
414 430,411,653
707 735,895,015
128 155,104,922
(3)Is there an index on the date field?
- Yes. But only in one table, which is the main table (records to purge in rest of the tables is based on this table).
(4)Can you drop unneeded indices during the window, and then rebuild them afterward?
- Not sure, if the time window within which the purge process must complete would be sufficient to do drop and rebuild of indices.
(5)How beefy is your hardware?
- No. of cores - 64
Memory - 128GB
Disk - SSD, Total capacity - 8.5TB
Thank you...This electronic mail (including any attachment thereto) may be confidential and privileged and is intended only for the individual or entity named above. Any unauthorized use, printing, copying, disclosure or dissemination of this communication may be subject to legal restriction or sanction. Accordingly, if you are not the intended recipient, please notify the sender by replying to this email immediately and delete this email (and any attachment thereto) from your computer system...Thank You.
