Parallel Group-By SQL Reset Options

SPD Server provides the following Parallel Group-By SQL reset options:

GRPSEL / NOGRPSEL

This option enables or disables the SPD Server Parallel Group-By facility.

Usage:

/* Disable Parallel Group-By */
execute(reset nogrpsel)
 by sasspds ;

This option enables or disables the SPD Server Parallel Group-By use of formats.

Usage:

/* Disable Parallel Group-By */
/* use of formats.            */
execute(reset nofmtgrpsel)
 by sasspds ;

Use this option to turn on and off the SPD Server Index Scan facility. The default SPD Server setting uses the Index Scan facility.

Usage:

/* Disable index scan facility */
execute(reset noscangrpsel)
 by sasspds ;

/* Enable index scan facility */
execute(reset scangrpsel)
 by sasspds ;