Execute Analyze Table Command

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

Questions by shanthiavari

Showing Answers 1 - 3 of 3 Answers

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 .

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions