DF213: Query hint is used.

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