Click or drag to resize

EX0015 : Find Best Clustered Index

The topic describes the EX0015 analysis rule.

Message

Find Best Clustered Index

Description

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.

Scope

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

Parameters

Rule has no parameters.

Remarks

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

Categories

Design Rules, Explicit Rules

Additional Information
See Also

Other Resources