Advanced options should be changed only by an experienced database professional. Reconfiguring certain options invalidates plans in the plan cache, causing new plans to be compiled. For more ...