SPD Server supports
parallel index creation using asynchronous index options. To enable
asynchronous parallel index creation, either submit the SPDSIASY=YES
macro variable before creating an index in SAS, or use the ASYNCINDEX=YES
table option.
Both the macro variable
and the table option apply to the DATA step INDEX= processing as well
as to PROC DATASETS INDEX CREATE commands. Either method allows all
of the declared indexes to be populated with a single scan of the
table. A single scan is a substantial improvement over making multiple
passes through the data to build each index serially.
As always, there is
a price for parallelism. To create multiple indexes requires enough
WORKPATH= disk space to create all of the key sorts at the same time.
The PROC DATASETS structure has the flexibility to allow batched parallel
index creation by using multiple MODIFY groups. The Parallel Index
Creation example below inserts INDEX CREATE statements between two
successive MODIFY statements resulting in a parallel creation group.