Skip to content

Latest commit

 

History

History
32 lines (22 loc) · 765 Bytes

SRP0012.md

File metadata and controls

32 lines (22 loc) · 765 Bytes

SQL Server Rule: SRP0012

Assembly SqlServer.Rules.dll
Namespace SqlServer.Rules.Performance
Class ConsiderIndexingInClauseColumnsRule

Rule Information

Id SRP0012
Friendly Name Un-indexed membership test
Category Performance
Ignorable true
Applicable Types Procedure
Scalar Function
Table Valued Function
View

Description

Consider indexing the columns referenced by IN predicates in order to avoid table scans.

Summary

Consider indexing the columns referenced by IN predicates in order to avoid table scans.