Different types of indexes in SQL

Question

Which are the different types of indexes in SQL?

in progress 0
Pragya Rani 55 years 1 Answer 775 views Contributor 0

Answer ( 1 )

  1. Clustered index: It is used for easy retrieval of data from the database by altering the way that the records are stored. Database sorts out rows by the column which is set to be clustered index.
    Nonclustered index: It does not alter the way it was stored but creates a complete separate object within the table. It points back to the original table rows after searching.

Leave an answer

Browse
Browse