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

Examples

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

Related reference
CREATE INDEX Statement