Create a table index
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
- Access the Index creator in one of the following ways.
| Option | Steps |
|---|---|
| Tables & Columns module |
|
| Database Indexes related list |
|
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.
To create a unique index, select the Unique Index check box.
Select Create Index.
The Table Name field is there for your reference only. Overriding the default has no effect.
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.
Parent Topic:Managing tables and indexes