Query hints can be really helpful in some scenarios, but if you do not have direct access to the code (hello third party applications), then you cannot add a query hint to the statement. Historically, you’ve been able to use a plan guide to apply a hint, and that doesn’t require direct code access, but plan guides are not always intuitive and I find that most people are not familiar with how to use them.
Enter Query Store Hints. With this feature, you can now add a hint to a specific statement, even if you don’t have access to the code base.
Read on to see what it does and how you can use it.