The NOSTARJOIN option
suppresses the use of the SPD Server STARJOIN optimizer in the planning
and running of SQL statements that have valid STARJOIN patterns or
star schemas. When NOSTARJOIN is enabled, SPD Server ignores STARJOIN
and uses pairwise joins to plan and run SQL statements. The default
setting is NOSTARJOIN=0, which means that STARJOIN is enabled, and
STARJOIN optimization occurs when SQL recognizes a valid SPD Server
pattern or star schema.
Usage:execute(reset nostarjoin=<1/0>)
by sasspds ;
NOSTARJOIN=0
enables the SPD Server
STARJOIN facility
NOSTARJOIN=1
disables the SPD Server
STARJOIN facility
Note: The statements NOSTARJOIN
and NOSTARJOIN=1 are equivalent.