Parallel Group-By SQL Options

The GRPSEL/NOGRPSEL option enables or disables the SPD Server Parallel Group-By facility.

Usage:

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

The FMTGRPSEL/NOFMTGRPSEL 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 the SCANGRPSEL/NOSCANGRPSEL option to turn the SPD Server index scan facility on and off. 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 ;