Creating Indexes

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.

1. In the explorer tree, select the table for which you want to create an index.

2. In the context menu of the table, choose Definition.

3. Open the Indexes tab page.

4. In the context menu of the editor window, choose Edit.

5. In the context menu of the editor window, choose Add Index.

6. Enter the index attributes.

   Table 1: Indexes

   Property	Description (Link to SQL Reference Manual)
   Name	Index Name (index_name)
   Unique	Specifies whether the values for this columns must be unique UNIQUE Definition (unique_definition)
   Disabled	Specifies whether the index is enabled or disabled
   Indexed Columns	Columns that are indexed
   Usage Count	Shows how often the system has used the index
   Bad	Shows whether the index is damaged

7. In the context menu of the editor window, choose Alter Table.

• Displaying Indexes

• Changing Index Properties

• Activating or Deactivating Indexes

• Recreating Damaged Indexes

• Activating or Deactivating the Automatic Recreation of Damaged Indexes

• Deleting Indexes

SQL Reference Manual, CREATE INDEX Statement (create_index_statement)