Specifies the number of threads to be used in a sort.
Integer
3
DBA permissions are not required to set this option. Can be set temporary, for an individual connection, or for the PUBLIC group. Takes effect immediately.
Use SORT_PHASE1_HELPERS to control the number of helper threads used by the sort object in phase1 (insertion). If set to 0, no helper threads are requested.
Use this option for performance analysis and tuning. If you change this option, experiment to find the best value to increase performance, as choosing the wrong value might decrease performance. Sybase recommends using the default value for SORT_PHASE1_HELPERS.
If your IQ temporary buffer cache is larger than 10GB, however, Sybase recommends setting the SORT_PHASE1_HELPERS option between 5 and 10.
