DF213: Query hint is used.

Last modified: May 28, 2025

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

Message

Query hint is used.

For better performance, avoid using query hints.

This rule is applied to the following hints:

SELECT id FROM dbo.DemoTable OPTION(FAST 2)
GO

SELECT id FROM dbo.DemoTable
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.