SA0195 : Duplicate statistics must be removed

Duplicate statistics must be removed

The rule checks current database and reports for automatically created statistics, which duplicate statistics created manually or by index.

Automatically created statistics can become obsolete by subsequent creation of indexes on the same columns.

These duplicate statistics are not removed automatically and will continue to consume resources, be updated and managed by SQL Server until dropped manually.

Drop the automatically created statistics that are reported as duplicate by the rule.

DROP STATISTICS schema_name.table_name.statistics_name;

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