Click or drag to resize

SA0044 : Consider creating indexes on all columns included in foreign keys

The topic describes the SA0044 analysis rule.

Message

Consider creating indexes on all columns included in foreign keys

Description

The rule checks for not indexed foreign keys in the current database.

Create an index on any foreign key as the foreign keys are used in joins almost always benefit from having an index.

It is better to create indexes on all foreign keys, despite the possible overhead of maintaining unneeded indexes than not to have index when needed.

Scope

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

Parameters
NameDescriptionDefault Value
MinimumRowsCount

Include only tables that have more than the specified minimum number of rows.

0

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