Procedure documentationCreating Indexes Locate this document in the navigation structure

 

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.

Prerequisites

Procedure

  1. In the context menu of the table for which you want to define the index, choose Definition.

  2. Open the Indexes tab page.

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

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

  5. Enter the index attributes.

    Indexes

    Property

    Description (Link to SQL Reference Manual)

    Index name

    Index Name (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

    UNIQUE Definition (unique_definition)

    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

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

More Information

SQL Reference Manual, CREATE INDEX Statement (create_index_statement)