DF205: Join hint is used.

Last modified: May 28, 2025

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

Message

Join hint is used.

For better performance, avoid using join hints.

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

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

Was this page helpful?

Yes

Take a quick tour to learn all about the key benefits delivered by dbForge Studio for SQL Server.

Get acquainted with the rich features and capabilities of the tool in less than 5 minutes.

If you consider employing this tool for your business, request a demo to see it in action.