Skip to content

Latest commit

 

History

History
32 lines (22 loc) · 681 Bytes

SRP0011.md

File metadata and controls

32 lines (22 loc) · 681 Bytes

SQL Server Rule: SRP0011

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

Rule Information

Id SRP0011
Friendly Name Non-member test in predicate
Category Performance
Ignorable true
Applicable Types Procedure
Scalar Function
Table Valued Function
View

Description

Avoid using the NOT IN predicate in a WHERE clause. (Sargable)

Summary

Avoid using NOT IN predicate in the WHERE clause.