Startup parameter
|
Description
|
Speed Sort (-TB)
|
Increase this parameter to 8K, 16K, or even 31K, particularly for index rebuild operations. Increasing this parameter increases memory usage during sorting and index rebuilds. It also slightly increases disk space usage.
|
Merge Number (-TM)
|
Increase this parameter to 32 to speed the merge phase of the sort process (at the cost of increased temporary memory usage).
|