Spotlight Essentials optimization hints warning appears for query without customer optimization hints (4278345)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Spotlight Essentials optimization hints warning appears for query without customer optimization hints
Description

Spotlight Essentials Best Practices raise warning about HINTS even if no special hints was used.
Cause

Spotlight Essentials evaluate this rule against the list of special keywords.
For list of these keywords please see SQL Server Documentation
Resolution

Here is one concrete case.
In this query you can see WITH() in green oval. This is one of SQL Server hints.
It is possible to click on Ignore button (on top of the box) and ignore warnings for this SQL query.
Additional Information

It is possible, that some code generators adding this hint automatically without user interaction (not confirmed). This may cause user confusion.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title