DF205: Join hint is used.

The topic describes the DF205 T-SQL code analysis rule.

Category

PERFORMANCE

Message

Join hint is used.

Description

For better performance, avoid using join hints.

Noncompliant code example

SELECT h.HeaderId
FROM dbo.Header h
    INNER LOOP JOIN dbo.Line l
    ON h.HeaderId = l.HeaderId
GO

Compliant solution

SELECT h.HeaderId
FROM dbo.Header h
  INNER JOIN dbo.Line l
    ON h.HeaderId = l.HeaderId
GO