R
Rob Fitzpatrick
Guest
In terms of future-proofing, having historical data is a huge boon. Set up a recurring monthly dbanalys, then parse the data and put it in a database. Look at the trends. Then, if you want to be cautious, you can either tablemove/idxmove or D&L selectively to get your fast-growing tables and their indexes into separate areas before they become huge and limit your restructuring options. Yes, in the short term that will leave a bit of wasted space in the multi-object areas they came from, but (a) disk space is cheap and (b) as those tables and indexes in the multi-object areas grow, you'll use up that space anyway.
Continue reading...
Continue reading...