BEGIN PARALLEL IQ … END PARALLEL IQ statement

Description

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

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

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.


Side effects

Automatic commit.

Standards

Permissions

None

See also

CREATE INDEX statement