Click or drag to resize

SA0046 : Consider creating statistics on all composite index columns

The topic describes the SA0046 analysis rule.

Message

Consider creating statistics on all composite index columns

Description

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.

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 Analysis Context. If context is missing, the rule will be skipped during analysis.

Categories

Performance Rules

Additional Information

There is no additional info for this rule.

See Also

Other Resources