SQL Server DBA

Query Store, execution plans, waits, blocking, and deadlock analysis

Question

Query Store plan forcing versus Query Store hints: how do they differ?

Answer

Plan forcing reuses a selected stored plan for a query. Query Store hints apply supported optimizer hints without changing query text or code. Use forcing for a known-good plan; use hints for a targeted optimizer behavior change that needs easier reversal.

This is 10 of 25 free samples for SQL Server DBA.

More SQL Server DBA topic samples