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
Want to Find out More?
Overview
Take a quick tour to learn all about the key benefits delivered by dbForge Studio for SQL Server.
All features
Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
Request a demo
If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for SQL Server?