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.
