Recompile

Tag: recompile

Does OPTION (RECOMPILE) Prevent Query Store from Saving an Execution Plan?

Does OPTION (RECOMPILE) Prevent Query Store from Saving an Execution Plan?

on November 25, 2015

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.

Continue reading