STATISTICS_NORECOMPUTE
STATISTICS_NORECOMPUTE = { ON | OFF }Specifies whether statistics are recomputed. The default is OFF. ONOut-of-date statistics are not automatically recomputed. OFFAutomatic statistics updating are enabled. The general recommendation to leave auto-update stats turned on (STATISTICS_NORECOMPUTE = OFF, which is the default) is for safety reasons, because if this is turned off and nothing is manually updating the stats,... » read more