If Adaptive Server 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.
