EX0015 : Find Best Clustered Index

The topic describes the EX0015 analysis rule.


Find Best Clustered Index


The rule uses the DMV-s to identify the non-clustered indexes that are candidates to become clustered indexes.
The non-clustered indexes are considered better compared to the existing clustered indexes if the number of user seeks on those indexes is greater than the number of lookups on the related to the table clustered index.

How to fix


The rule has a ContextOnly scope and is applied only on current server and database schema.


Rule has no parameters.


The rule requires SQL Connection. If there is no connection provided, the rule will be skipped during analysis.

Effort To Fix
3 hours per issue.

Design Rules, Explicit Rules, Code Smells

Additional Information
See Also

Other Resources