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

  • Interview Candidate
  • 4
  • 4077

Showing Answers 1 - 4 of 4 Answers

hema

  • Jun 16th, 2005
 

You have to run the analyze command during off peak time only because it actually performs full table scan.

Chiranjeevi Manne

  • Mar 30th, 2007
 

The ANALYZE requires significant system resources, So it is always better to run the ANALYZE command during off peak hours.

  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