Settings lead to procedure recompilation (only in proc/trigger) 

Setting this option from within batch leads to batch recompilation. 

Where possible, batches, triggers and procedures should be compiled just once and their plans reused when called again. This yields better performance and uses less memory resource. Anything that changes the execution context will force a recompile.

Didn't find what you were looking for?