What is an Index?

Question

Describe Types as well

in progress 0
Pragya Rani 4 years 1 Answer 993 views Contributor 0

Answer ( 1 )

  1. Indexes are special lookup tables that the database search engine can use to speed up data retrieval. Simply put, an index is a pointer to data in a table. An index in a database is very similar to an index in the back of a book.
    A clustered index 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.
    A nonclustered index does not alter the way it was stored but creates a completely separate object within the table. It point back to the original table rows after searching.

Leave an answer

Browse
Browse