SPDSCLJX Macro Variable

Affects the SAS SQL planner when a SAS table is being joined with an indexed SPD Server table.

Valid in: SPD Server
Default: NO
Restriction: Assignments for macro variables with character input (for example, YES | NO | BINARY arguments) must be entered in uppercase (capitalized).
Syntax
Required Arguments
Details

Syntax

SPDSCLJX=YES | NO

Required Arguments

YES

The SAS SQL planner includes the index join as a possible method for joining a Base SAS table with an SPD Server cluster table.

NO

The SAS SQL planner disallows the index join as a possible method for joining a Base SAS table with an SPD Server cluster table.

Details

SPDSCLJX=YES can potentially improve processor performance during heterogeneous joins between an SPD Server cluster table and Base SAS table. Index joins tend to be most beneficial when there are relatively few rows in the SAS table.
Note: The SPDSCLJX macro variable has no effect on implicit or explicit join queries to SPD Server that involve a cluster table.
Copyright © SAS Institute Inc. All Rights Reserved.
Last updated: February 8, 2017