Groups CREATE INDEX statements together for execution at the same time.
... BEGIN PARALLEL IQ statement-list ... END PARALLEL IQ
BEGIN PARALLEL IQ
CREATE HG INDEX c1_HG on table1 (col1);
CREATE HNG INDEX c12_HNG on table1 (col12);
CREATE LF INDEX c1_LF on table1 (col1);
CREATE HNG INDEX c2_HNG on table1 (col2);
END PARALLEL IQ
The BEGIN PARALLEL IQ … END PARALLEL IQ statement lets you execute a group of CREATE INDEX statements as though they are a single DDL statement, creating indexes on multiple IQ tables at the same time. While this statement is executing, you and other users cannot issue other DDL statements.