Index and its advantages and disadvantages

Indexes use a data structure to improve the efficiency of data operations in the database. Its disadvantage is that it requires additional space, it is time-consuming to create an index, and the index must be updated when the record changes.

 

Indexes include clustered indexes and non-clustered indexes. Clustered indexes directly store data pagination, and fee clustered indexes only store pages directed to data pagination.

 

 Index

IndexIs a data structure to improve the data retrieval operations on a database table.

TheDisadvantageOf the index has follows:

1. Need more storage space.
2. Crate index is time consuming.
3. Have to maintain the index when the records change.

There are two type indexes:Cluster IndexAndNon-Cluster Index. Cluster Index stores the data pages, while the non-Cluster Index stores the pages point to the data pages.