Does OPTION (RECOMPILE) Prevent Query Store from Saving an Execution Plan?
Category:
query-performance
Recompile hints have been tough to love in SQL Server for a long time. Sometimes it’s very tempting to use these hints to tell the optimizer to generate a fresh execution plan for a query, but there can be downsides.