Specifies the number of threads to be used in a sort.
Integer.
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.
3
SORT_PHASE1_HELPERS is used to control the number of helper threads used by the sort object in phase1 (insertion). If set to 0, no helper threads are requested.
This option is used for performance analysis and tuning. If you change this option, you must experiment to find the best value to increase performance, as choosing the wrong value may 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 in the range of 5 to 10.
