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.