Summary information |
|
|---|---|
Default value |
500 |
Range of values |
0–32767 |
Status |
Dynamic |
Display level |
Comprehensive |
Required role |
System Administrator |
number of sort buffers specifies the number of 2K buffers used to hold pages read from input tables and perform index merges during sorts.
Sybase recommends that you leave this parameter set to the default except when you are creating indexes in parallel. Setting the value too high can rob non-sorting processes of access to the 2K buffer pool in caches being used to perform sorts.
For more information on configuring this value for parallel create index statements, see “Caches, sort buffers, and parallel sorts” in the Performance and Tuning: Optimizer and Abstract Plans.
