Just wondering if anybody's ever done this... DBREINDEX x 2
Posted on 2009-04-09
v2000, four tables, one is freeking huge. the other three or similarly huge, but not as bad as the other. Say I've got 2B records in one, and a bit less than that in the others.
(B = billion)
heavily fragmented, i need to defrag. the last time i did this, it took 46hrs. completed successfully.. just rather timely. surely it's going to be greater this time around, as the data is never purged.
i'm starting to wonder... what if i split it up, two different jobs: two tables in one, two tables in the other, and ran them in parallel? fully dedicated machine, completely dedicated to me and only me, throughout the Easter weekend.
What do you think? Might that be too harsh to the machine? It should be ok... don't you think?
ample, ample disk space on all drives... simple recovery model... so i'm not too worried about chewing tons of disk. But.... maybe I should be more worried.
I don't know.
Anybody ever tried anything like this?