Build indexes to access the data held in your tables more easily.

Before you begin

Role required: admin

About this task

Note: Constructing an effective index requires specialized knowledge in database architecture. If you don't have this expertise, consult with a database administrator.

Creating an index on a large table can significantly affect system performance. A large table in this case is generally considered to be any table around 1 TB in size. Therefore, consider creating indexes on larger tables only during off-peak hours. For example, avoid adding an index to a CMDB table while a discovery job is running, as this can lead to increased load and potential delays.

Procedure

  1. Access the Index creator in one of the following ways.
    OptionSteps
    Tables & Columns module
    1. Navigate to All > System Definition > Tables & Columns.
    2. In the list, find the table you want and select its label.
    3. Navigate to the Index creator.
    Database Indexes related list
    1. Navigate to All > System Definition > Tables.
    2. In the list, find the table you want and select its label.
    3. Navigate to the Database Indexes related list.
    4. Select New.
  2. Select the fields you want included in the index.
    The order in which you select the fields affects how the index works. If you do not have expertise in database design, you should consult someone who does.
  3. To create a unique index, select the Unique Index check box.
  4. Select Create Index.
    The Table Name field is there for your reference only. Overriding the default has no effect.
  5. Select an index type.
    • btree
      The default index type.
    • Columnstore (RaptorDB Pro)
      Optimize data storage and retrieval by creating a columnstore index. Columnstore indexes store data in a compressed, column-oriented format that can improve query performance, especially when querying large datasets. Available with RaptorDB Professional.