Advantages of Clustered Index

The pros/benefits of the clustered index are:
  • Clustered indexes are an ideal option for range or group by with max, min, count type queries
  • In this type of index, a search can go straight to a specific point in data so that you can keep reading sequentially from there.
  • Clustered index method uses location mechanism to locate index entry at the start of a range.
  • It is an effective method for range searches when a range of search key values is requested.
  • Helps you to minimize page transfers and maximize the cache hits.

No comments:

Post a Comment