Index Used More Than the Clustered

This warning has been raised because SQL Server's statistics indicate that this index has been used for more queries than the clustered index.

Clustered indexes are the most efficient indexes for reading data from a table, so ideally should be the indexes used most. Consider whether this index should be swapped with the clustered index.

⚠ This warning is purely based on SQL Server's statistics, which are only populated by querying of the database. If the database has just been restarted or restored, or it's a replica database that is never used for selects, then the statistics will not accurately represent whether the index is used or not.

Suggested Action

Consider changing the clustered index, but you should also monitor the change in page splits, scans, and seek counts during testing.

Further Reading

Clustered and Nonclustered Indexes Described | Microsoft Docs