DF213: Query hint is used.
Last modified: December 25, 2024
The topic describes the DF213 T-SQL code analysis rule.
Category
PERFORMANCE
Message
Query hint is used.
Description
For better performance, avoid using query hints.
Additional information
This rule is applied to the following hints:
- DELETE
- INSERT
- SELECT
- UPDATE
- MERGE
Noncompliant code example
SELECT id FROM dbo.DemoTable OPTION(FAST 2)
GO
Compliant solution
SELECT id FROM dbo.DemoTable
GO
Was this page helpful?