Shortest Route to Run Statistics?

Database

Shortest Route to Run Statistics?

We recently ran a job to collect statistics on 2 tables which ran from 8PM to 7AM. The job collected on 45 columns for one table and 67 columns for the other. It did run during our first of the month reports and there were around 180 sessions going and many reports being requested so we understand the long run time. Our question is would it possibly have been faster, in general, to run 2 separate collect stats jobs in parallel than to sequence them in one job?
1 REPLY
Enthusiast

Re: Shortest Route to Run Statistics?

why dont you use sampling while collecting statistics on some of the columns.
you should be careful in choosing the columns though. This way the stats are collected much faster.