Groups CREATE INDEX statements together for execution at the same time.
... BEGIN PARALLEL IQ statement-list ... END PARALLEL IQ
a list of CREATE INDEX statements
The following statement executes atomically. If one command fails, the entire statement rolls 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
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.
You can specify multiple tables within the statement list. Granularity is at the column level. In other words, multiple indexes on the same column are executed serially.
Automatic commit.
Sybase Not supported by Adaptive Server Enterprise. For support of statements inside the statement, see CREATE INDEX statement.
None
