BEGIN PARALLEL IQ … END PARALLEL IQ Statement

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

Quick Links:

Syntax

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

Parameters

(back to top)

statement-list
a list of CREATE INDEX statements

Examples

(back to top)

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

(back to top)

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.
This statement does not support TEXT indexes.

Side effects:

Automatic commit

Standards

(back to top)

SQL—Vendor extension to ISO/ANSI SQL grammar.
SAP Database products—Not supported by SAP ASE. For support of statements inside the statement, see CREATE INDEX Statement.

Permissions

(back to top)

None