EX0015 : Find Best Clustered Index

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

SQL Server Dynamic Management Views

Other Resources