T-SQL Analyzer

# SQL Server Rule: SRP0018 | | | |----|----| | Assembly | SqlServer.Rules | | Namespace | SqlServer.Rules.Performance | | Class | QueryHighJoinCountRule | ## Rule Information | | | |----|----| | Id | SRP0018 | | Friendly Name | High join count | | Category | Performance | | Ignorable | false | | Applicable Types | Procedure | | | Scalar Function | | | Table Valued Function | | | View | ## Description Query uses a high number of joins. ## Summary Reduce number of joined relations. ### Remarks Queries that use a high number of joins will cause the compiler to time out trying to find a good execution plan. Consider re-arranging the tables in the joins from smallest to largest table and applying the FORCE ORDER query hint. _{^{Generated by a tool}}