CREATE INDEX Format 2 (Define index)
Function
CREATE INDEX (format 2) defines an index of a specified index type.
Privileges
A user can define indexes in public user RDAREAs for tables owned by that user.
A user can define indexes for tables owned by that user in private user RDAREAs for which the user has the privilege.
Format 2 (Define index of a specified index type)
CREATE INDEX [authorization-identifier.] index-identifier
USING TYPE [authorization-identifier.] index-type-identifier
ON [authorization-identifier.] table-identifier (column-name)
IN {RDAREA-name
|(RDAREA-name)
|((RDAREA-name)[, (RDAREA-name)]...)
|matrix-partitioned-index-storage-RDAREA-specification}
[index-option]...
[PLUGIN plug-in-option]
matrix-partitioned-index-storage-RDAREA-specification::=
two-dimensional-storage-RDAREA-specification
two-dimensional-storage-RDAREA-specification::=
(matrix-partitioning-RDAREA-list
[, matrix-partitioning-RDAREA-list]...)
matrix-partitioning-RDAREA-list::=
(RDAREA-name[, RDAREA-name]...)
index-option ::= EMPTY
Operands
Specifies the authorization identifier of the user who will own the created index and specifies a name for the index.
The index name cannot be the same as the table name.
Specifies the name of the RDAREA for storing indexes.
When defining an index for a matrix-partitioned table, specify a matrix-partitioned index storage RDAREA.
The following rules apply to RDAREAs that store an index:
Specifies that an empty plug-in index is being created.
The EMPTY option improve the capacity for concurrent execution of plug-in index definitions. This option is also effective when a table contains a large amount of data and the definitions of multiple indexes must be executed concurrently. This option is not effective for tables that do not contain data.
For details of using the EMPTY option, see the HiRDB Version 8 System Operation Guide.
Specifies as a character string literal (of up to 255 characters) parameter information for the plug-in index. Hexadecimal character string literals cannot be specified as parameter information. For details about the parameter information, see the documentation for the appropriate plug-in.
Common rules
Notes