SA0046 : Consider creating statistics on all composite index columns

Consider creating statistics on all composite index columns

SQL Server creates statistics only for the first key column of a composite index when the index is created.

The rule checks for all composite index key columns other than the first one, which do not have statistics stored.

Review the key columns of the composite index and manually create statistics for key columns besides the first key column.

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

Rule has no parameters.

The rule requires Analysis Context. If context is missing, the rule will be skipped during analysis.

Performance Rules, Bugs

There is no additional info for this rule.

Other Resources