SA0044 : Consider creating indexes on all columns included in foreign keys
The topic describes the SA0044 analysis rule.
Consider creating indexes on all columns included in foreign keys
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.
The rule has a ContextOnly scope and is applied only on current server and database schema.
Include only tables that have more than the specified minimum number of rows.
The rule requires Analysis Context. If context is missing, the rule will be skipped during analysis.
There is no additional info for this rule.
© Ubitsoft Ltd. All Rights Reserved.