The following table lists the startup parameters you use to improve performance when sorting records for reports and during index rebuild operations.

Table 1. Startup parameters for tuning sort performance
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).

For more information about these startup parameters, see Startup Command and Parameter Reference.