An index is a database object that can be defined for an individual column or a series of columns in a database table. It consists of one or more inversion lists. An index may improve the performance of the database system.
You are logged on to the database as a database user.
You have the INDEX privilege for the table.
More information: SQL Reference Manual, Privilege Specification (privilege_specification)
The database is in the ONLINE operational state.
In the context menu of the table for which you want to define the index, choose Definition.
Open the Indexes tab page.
In the context menu of the editor window, choose Edit.
In the context menu of the editor window, choose Add Index.
Enter the index attributes.
Property |
Description (Link to SQL Reference Manual) |
---|---|
Index name |
|
In Index |
Indicates whether a column belongs to the index |
Sort |
Sort sequence |
Name |
Column name |
Data Type |
Column data type You cannot use LOB columns in an index. |
Unique |
Indicates whether the values for this columns must be unique |
Disabled |
Indicates whether the index is deactivated |
Usage Count |
Indicates how often the system has used the index |
Bad |
Indicates whether the index is damaged |
In the context menu of the editor window, choose Alter Table.
SQL Reference Manual, CREATE INDEX Statement (create_index_statement)