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.

Note: This statement does not support RLV-enabled tables.

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