An Indexes object represents a collection of Indexes of a Historic on a database table, which improves the performance of queries that use this Index. Indexes are used to find records with a specific value on a column quickly. Without an Index, a Database must start with the first record and then read the whole table until it finds all relevant records. The larger the table, the higher the cost of this operation. If a table contains an Index for those columns, the Database can quickly retrieve a position to search through the data file without traversing the whole table, thus optimizing access to records.

All types of columns of a table can be indexed. Using Indexes on relevant columns is the best way to improve a table's performance. The maximum number of Indexes per table and the maximum size of an Index is defined by the storage mechanism of the Database Server. Users can create Indexes on multiple columns, which can be considered as ordered arrays containing values created by concatenating values from indexed columns.

To insert an Indexes object on a Historic, right-click a Historic and select the Add - Indexes option. Please check topic Historic Index for more information about the Indexes that can be inserted in this object and check topic Index Field for more information about the Fields that can be inserted in Indexes.