Index of the database

An index is a structure that sorts the values of one or more columns in a database, using an index to quickly access specific information in a database table.

An index is a structure that sorts the values of one or more columns in a database table, such as the name (name) column of the employee table. If you want to find him or her by the name of a particular employee, the index helps you get information faster than searching all the rows in the table.


Clustered index: Dead according to the physical location of the data stored in order, can improve the speed of multi-row retrieval.

Nonclustered index: Fast for single-line retrieval.

There are three types of indexes: Unique index, primary key index, and clustered index.

Index of the database