I wrote about query store hints before when they were first released in Azure SQL databases.
However, there are some tricks related to managing query store hints we will explore on this blog post.
Applying Query Store Hint
When we apply a query store hint, the query already exists in query store, and it has at least one plan registered. It’s even possible to have more.
The query hint will only be applied to further executions of the query, so the existing plans in query store don’t have the query hint applied.
The query store DMVs have relationships to each