Specifies to suppress index use during a BY sort.
| Valid in: | SPD Server |
| Default: | NO |
| Restrictions: | The SPDSNBIX macro variable cannot enable index use for BY sorts. It can suppress index use when index use for BY sorts is enabled on the server. The corresponding server parameter is BYINDEX. |
| Assignments for macro variables with character input (for example, YES | NO | BINARY arguments) must be entered in uppercase (capitalized). |
suppresses index use during a BY sort. If the distribution of the values in the table are not relatively sorted or clustered, using the index for the BY sort can result in poor performance.
uses indexes for BY sorts, if index use for BY sorts is enabled on the server.
%let SPDSNBIX=YES;