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.
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.
Design Rules, Explicit Rules, Code Smells