I've been asked to enable auto create statistics and auto update statistics on a production database that is suffering perfmormance problems. This seems a sensible move.
However, I'm concerned about an inital performace hit when I turn auto create statistics on. When does the creation of statistics actually take place?
View Complete Post