T-SQL Analyzer

# SQL Server Rule: SRP0011 | | | |----|----| | Assembly | SqlServer.Rules | | 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. ### Remarks Using NOT IN predicate in the WHERE clause generally performs badly, because the SQL Server optimizer has to use a TABLE SCAN instead of an INDEX SEEK even the filtering columns are covered by index. _{^{Generated by a tool}}