Statistics are tied hand and hand with indexes as without indexes predicates don't care about statistics as you are returning the whole of a column. Trace flag 2371 was mentioned in a slide. Updating statistics comes with a performance hit, but you can turn on this flag to force it to happen more frequently whenever a significant number of rows are altered.
No comments:
Post a Comment