BEGIN PARALLEL IQ … END PARALLEL IQ Statement

Groups CREATE INDEX statements together for execution at the same time.

Syntax

... BEGIN PARALLEL IQ
 statement-list
... END PARALLEL IQ

Parameters

statement-list – a list of CREATE INDEX statements

Examples

Example 1 – This 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

Usage

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.

Note: This statement does not support TEXT indexes.

Side effects:

Automatic commit

Standards

SQL—Vendor extension to ISO/ANSI SQL grammar.
Sybase—Not supported by Adaptive Server Enterprise. For support of statements inside the statement, see CREATE INDEX Statement.

Permissions

None