SPDSWCST Macro Variable

Specifies whether to use dynamic WHERE clause costing.

Valid in: SPD Server
Default: YES
Restriction: Assignments for macro variables with character input (for example, YES | NO | BINARY arguments) must be entered in uppercase (capitalized).
Interaction: Corresponding server parameter option is WHERECOSTING.
Syntax
Required Arguments
Details
Example
See Also

Syntax

SPDSWCST=YES | NO

Required Arguments

YES

use dynamic WHERE clause costing.

NO

do not use dynamic WHERE clause costing.

Details

The SPDSWCST macro variable enables you to turn dynamic WHERE clause costing off if the server is configured with the WHERECOSTING server parameter. If the server is configured with the NOWHERECOSTING server parameter, any declaration of values using SPDSWCST is ignored.
WHERE clause costing causes WHINIT to use a heuristic method to determine (among other things) which indexes to use to evaluate the WHERE clause. When WHERE costing is disabled, WHINIT uses a rules-based evaluation that includes all available indexes to evaluate the WHERE clause.
SPDSWCST=NO affects all server connections.

Example 

%let SPDSWCST=NO;

See Also

Concepts:
WHERE Clause Planner
Copyright © SAS Institute Inc. All Rights Reserved.
Last updated: February 8, 2017