ASYNCINDEX= Table Option

When you are creating multiple indexes on an SPD Server table, specifies whether to create the indexes in parallel.

Valid in:	SPD Server
Default:	No
Interaction:	Corresponding macro variable is SPDSIASY.

Syntax

Required Arguments

Details

Example

Syntax

ASYNCINDEX=YES | NO

Required Arguments

YES

creates the indexes in parallel.

NO

creates a single index at a time.

Details

SPD Server can create multiple indexes for a table at the same time. To do this, it launches a single thread for each index created, and then processes the threads simultaneously. Although creating indexes in parallel is much faster, the default for this option is NO. The reason is because parallel creation requires additional sort work space that might not be available.

For a complete description of the benefits and trade-offs of creating multiple indexes in parallel, see SPDSIASY Macro Variable.

Example

When the disk work space required for parallel index creation is available, specify ASYNCINDEX=YES for the server to create, in parallel, the X, Y, and COMP indexes for table A.

PROC DATASETS lib=mydatalib;
   modify a(asyncindex=yes);
   index create x;
   index create y;
   index create comp=(x y);
   quit;

ASYNCINDEX= Table Option

Syntax

Required Arguments

YES

NO

Details

Example

See Also