Create a table index

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

시작하기 전에

Role required: admin

이 태스크 정보

주:

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.

프로시저

1. Access the Index creator in one of the following ways.

   Option	Steps
   Tables & Columns module	Navigate to All > System Definition > Tables & Columns. In the list, find the table you want and select its label. Navigate to the Index creator.
   Database Indexes related list	Navigate to All > System Definition > Tables. In the list, find the table you want and select its label. Navigate to the Database Indexes related list. 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.