OPTION (RECOMPILE) is Always Faster; Why?
There are times that using OPTION(RECOMPILE) makes sense. In my experience the only time this is a viable option is when you are using dynamic SQL. Before you explore whether this makes sense in your situation I would recommend rebuilding your statistics. This can be done by running the following: EXEC sp_updatestats And then recreating … Read more