How to Execute 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.

These keywords can only be used when creating indexes on IQ tables, not temporary tables or SQL Anywhere tables. If one of these CREATE INDEX statements fails, they all roll back. See Reference: Statements and Options.