Executing Groups of CREATE INDEX Statements

Use the keywords BEGIN PARALLEL IQ and END PARALLEL IQ to delimit any number of CREATE INDEX statements that you want to execute as a group at the same time.

Use these keywords only to create indexes on base tables in the IQ main store, not temporary tables or catalog store tables.

If any of these CREATE INDEX statements fails, they all roll back.

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