STARSIZE= Parameter File Option

Specifies the amount of memory to allocate for STARJOIN operations.

Valid in: spdsserv.parm parameter file
Interaction: When STARSIZE= is omitted, SORTSIZE= applies. See SORTSIZE= Parameter File Option.
Syntax
Required Argument
Details

Syntax

STARSIZE=n | nK | nM | nG;

Required Argument

n

specifies a number that indicates the amount of memory to allocate for STARJOIN operations in terms of bytes (1), kilobytes (1,024 bytes), megabytes (1,048,576 bytes), or gigabytes (1,073,741,824 bytes).

Details

During STARJOIN operations, the temporary results of Phase 1 of the IN-SET STARJOIN strategy are cached in memory for use by Phase 2 if there is sufficient STARSIZE= memory. Caching Phase 1 temporary results can result in significant performance improvements for STARJOIN. If you omit STARSIZE=, STARJOIN uses the SORTSIZE= option to determine the memory to use for Phase 1 caching.
Copyright © SAS Institute Inc. All Rights Reserved.
Last updated: February 3, 2017