R
Rob Fitzpatrick
Guest
> In fact, the time needed for the data scan fase stayed about the same(about 2.5 hours) If the time didn't change then perhaps the data scan phase(s) were not multi-threaded. Check the output in the log, you will see messages indicating the data scan was multi-threaded, if it was. For -datascanthreads to take effect for an area, four conditions must be satisfied: - the area being scanned is a Type II area; - you answered "yes" when asked if you have enough disk space for sorting; - none of the indexes being rebuilt are in the area being scanned; - none of the tables in the area being scanned has a word index.
Continue reading...
Continue reading...