Create a table index
-
- UpdatedAug 1, 2024
- 1 minute read
- Xanadu
- Table Administration
Build indexes to access the data held in your tables more easily.
Before you begin
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