DataGrip
 
Get DataGrip
You are viewing the documentation for an earlier version of DataGrip.

Indexes

Last modified: 22 September 2023

A database index is a structure that is 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 can be seen in the Database Explorer. You can see a reference on node and object icons in the Data sources and their elements chapter of Database Explorer topic.

For the table column icons, refer to Possible icon combinations for columns.