Press "Enter" to skip to content

When Query Store Plan Forcing Fails

Milos Radivojevic notes a peculiarity with Query Store:

Be very careful with forcing plans against queries referencing table variables and table valued parameters. The query_id attribute for such queries is very instable and forcing plans even as a workaround could have very short life time. You should use different approach to fix such issues.

Read the whole thing to understand why this is important.