- WITH INDEX(index-specification [, index-specification] ...)
Specifies the index to be used. If multiple indexes are specified, the operation uses multiple indexes.
Suppresses the use of an index (table scanning).
- [[authorization-identifier.]index-identifier | PRIMARY KEY | CLUSTER KEY | PRIMARY CLUSTER KEY]
- authorization-identifier
- Specifies the authorization identifier of the user who owns the index. For default values, see 1.1.8 Qualifying a name.
- index-identifier
- Specifies the name of the index to be used.
- PRIMARY KEY
- Specifies the option of when to use an index that is defined by specifying a primary key (or a primary cluster key) during table definition. For primary and cluster keys, see CREATE TABLE.
- CLUSTER KEY
- Specifies the option of when to use an index that is defined by specifying an index key (or a primary cluster key) during table definition.
- PRIMARY CLUSTER KEY
- Specifies the option of when to use an index that is defined by specifying a primary cluster key during table definition.