Forum Post: RE: Multi-Threaded Update Statistics

  • Thread starter Thread starter Paul Koufalis
  • Start date Start date
Status
Not open for further replies.
P

Paul Koufalis

Guest
I have two DBs with some large tables to update stats on and this is on the DEV/TEST box so the disk I/O subsystem is not great. One table with 237M records and a size of 26 Gb took 3h to do a full table/index/column update stats. There is a 45Gb/430M records table running now. I never tried to "tune" this to make it faster. Is there anything that can be done on the sql side?

Continue reading...
 
Status
Not open for further replies.
Back
Top