In which situation whether peak time or off peak time you will execute the ANALYZE TABLE command. Why?

harisivati

 Profile Answers by harisivati Questions by harisivati

• Jul 13th, 2008

 Gathering statistics can be very resource intensive for the server so avoid peak workload times to gather stale stats or Analyze Table .

Answer Question  Select Best Answer