SAP ASE includes a parallel form of create index that uses the
query execution engine to more efficiently execute the command.
Configuring enhanced parallel create index
Enhanced parallel create index is disabled by default, and is part of the enable functionality group configuration parameter.
Enhanced Parallel create index Usage
Once SAP ASE is configured for parallel create index, it determines if using parallel execution to execute create index is the best choice.
View Parallel create index Commands with showplan
If SAP ASE is configured for parallel create index and chooses an enhanced parallel create index query plan, showplan displays information about the create index commands below the PLL CREATE INDEX COORDINATOR operator and CREATE INDEX operators.