| Assembly | SqlServer.Rules.dll |
| Namespace | SqlServer.Rules.Design |
| Class | ForeignKeysNeedIndexRule |
| Id | SRD0004 |
| Friendly Name | Index on Foreign Key |
| Category | Design |
| Ignorable | false |
| Applicable Types | Foreign Key Constraint |
Columns on both sides of a foreign key should be indexed.
Consider indexing columns on both sides of a foreign key relationship.