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.

For example:

create index i1 on t5(c1) with consumers = 3
. . .

QUERY PLAN FOR STATEMENT 1 (at line 1).
Executed in parallel by coordinating process and 3 worker processes.

STEP 1
  The type of query is CREATE INDEX.

  5 operator(s) under root

|ROOT:EMIT Operator (VA = 5)
|
|  |PLL CREATE INDEX COORDINATOR Operator
|  |
|  |  |EXCHANGE Operator (VA = 3) (Merged)
|  |  |Executed in parallel by 3 Producer and 1 Consumer processes.

|  |  |
|  |  |  |EXCHANGE:EMIT Operator (VA = 2)
|  |  |  |
|  |  |  |  |CREATE INDEX Operator
|  |  |  |  |
|  |  |  |  |  |SCAN Operator (VA = 0)
|  |  |  |  |  |  FROM TABLE
|  |  |  |  |  |  t5
|  |  |  |  |  |  Table Scan.
|  |  |  |  |  |  Forward Scan.
|  |  |  |  |  |  Positioning at start of table.
|  |  |  |  |  |  Executed in parallel with a 3-way range repartitioning scan.
|  |  |  |  |  |  Using I/O Size 16 Kbytes for data pages.
|  |  |  |  |  |  With MRU Buffer Replacement Strategy for data pages.