What is ANALYZE TABLE statement?

Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.

What is ANALYZE TABLE statement?

Rating:

The ANALYZE TABLE statement is used for analyzing a table for the following purposes:

  • Verify the validity of the storage format of the table.
  • Collect and manage statistics for the table.
  • Identify migrated and chained rows in the table.
The statistics collected are stored in the data dictionary. The statistics are utilized by the optimizer in choosing the most appropriate execution plan for statements issued against the associated table.


Rating:



Other articles

Click here to Article home

 
uCertify.com | Our Company | Articles | Privacy | Security | Contact Us
MCSE: MCSA, MCTS, MCITP    JAVA Certification: SCJP, SCWCD Cisco Certification: CCNA, CCENT, A+, Network+, Security+
Oracle Certification: OCP 9i, OCP 10g, OCA 9i, OCA 10g CIW foundation    EC-212-32    CISSP    Photoshop ACE    Adobe Flash ACE
© 2008 uCertify.com. All rights reserved. All trademarks are the property of their respective owners.