How long does update statistics take

Nov Note, though, that updating statistics causes queries to All you need to do is to find the middle ground between the time it takes to. When you run the statement UPDATE STATISTICS to generate a maintenance plan, you may notice that the UPDATE STATISTICS takes a very long time (approximately. Oct If we were to perform a trace we would see a Sch-M lock get taken very briefly at the end of the statistics update when the old stats and new.