29 lines (19 loc) · 636 Bytes

SQL Server Rule: SRD0004


Assembly	SqlServer.Rules.dll
Namespace	SqlServer.Rules.Design
Class	ForeignKeysNeedIndexRule

Rule Information


Id	SRD0004
Friendly Name	Index on Foreign Key
Category	Design
Ignorable	false
Applicable Types	Foreign Key Constraint

Description

Columns on both sides of a foreign key should be indexed.

Summary

Consider indexing columns on both sides of a foreign key relationship.