Skip to content

Latest commit

 

History

History
32 lines (22 loc) · 740 Bytes

SRP0009.md

File metadata and controls

32 lines (22 loc) · 740 Bytes

SQL Server Rule: SRP0009

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

Rule Information

Id SRP0009
Friendly Name Filtering on calculated value
Category Performance
Ignorable true
Applicable Types Procedure
Scalar Function
Table Valued Function
View

Description

Avoid wrapping columns within a function in the WHERE clause. (Sargable)

Summary

Avoid wrapping columns within a function in the WHERE clause. This affects sargability.