Skip to content

SRP0014.md

Latest commit

 

History

History
31 lines (21 loc) · 695 Bytes

SRP0014.md

File metadata and controls

31 lines (21 loc) · 695 Bytes

SQL Server Rule: SRP0014
Assembly SqlServer.Rules.dll
Namespace SqlServer.Rules.Performance
Class AvoidTableVariableInJoinsRule

Rule Information
Id SRP0014
Friendly Name Table variable in JOIN
Category Performance
Ignorable true
Applicable Types Procedure
Scalar Function
Table Valued Function

Description

Avoid the use of table variables in join clauses.

Summary

Avoid the use of table variables in join clauses planning and maintenace hazard.