Indexes

Last modified: 09 December 2024

A database index is a structure used to speed up locating and accessing operations in a database table. By using indexes, you decrease the number of disk accesses that are required when a query is processed. You can create indexes for one or more columns of a database table.

Indexes ( Index) can be found in the Database tool window. For the reference on other node and object icons, refer to the Data sources and their elements chapter of Database tool window topic. For the table column icons, refer to the Possible icon combinations for columns chapter.

Indexes in Database

For MongoDB, indexes are supported for database versions 4.0 and later. Currently, only the abilities to display and drop indexes are supported.