Skip to content

Latest commit

 

History

History
32 lines (22 loc) · 735 Bytes

SRD0032.md

File metadata and controls

32 lines (22 loc) · 735 Bytes

SQL Server Rule: SRD0032

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

Rule Information

Id SRD0032
Friendly Name Avoid use of OR in where clause
Category Design
Ignorable true
Applicable Types Procedure
Scalar Function
Table Valued Function
View

Description

Try to avoid the OR operator in query where clauses if possible. (Sargable)

Summary

Try to avoid the OR operator in query where clauses if possible. This affects sargability.