A
ashutosh.rai
Guest
I am in similar situation and have few questions 1) I have few large archive tables (100GB)+ which does not change anymore but needs to be in the database for some compliance reasons. I am planning to dump/load/reindex them in advance (Outside of outage window) . WIll proutil idxbuild all rebuild indexes on these large tables again? Does pre-building index on some of these archive tables save any time when we are running proutil idxbuild all after loading all data? 2) In some of the large transaction tables past data does not change (historical orders), can partial dump/reload/reindex with PROUTIL DUMPSPECIFIED for older data reduce maintenance window?
Continue reading...
Continue reading...