Skip to main content

In particular cases ForceRecompile can be a big help to improve load times in the Universal GUI. However this only works with select statements at the moment.

Today I encountered an update statement that goes from 1100 ms to 80 ms in SSMS when adding Option(Recompile) manually. It would be highly beneficial in this case if ForceRecompile was also available for update statements. I'd like to see this implemented in ForceRecompile or possibly a new extended property if that’s preferred.

Be the first to reply!