• An Index is a key built from one or more columns in the database that speeds up fetching rows from the table or view.
  • Cluster index is a type of index which sorts the data rows in the table on their key values.
  • A Non-clustered index stores the data at one location and indices at some other location
  • Clustered is the default index
  • The main benefit of a non-clustering index helps you to retrieves data quickly from the database table.
  • The main benefit of the Clustered index method is that it uses location mechanism to locate index entry at the start of a range.
  • In Clustered Index you can sort the records and store clustered index physically in memory as per the order while In non-clustered index helps you to creates a logical order for data rows and uses pointers for physical data files.
  • The main drawback of a clustered index is that it creates lots of constant page splits, which includes data page as well as index pages.

No comments:

Post a Comment