Tuesday, March 19, 2013

What is the use of ANALYZE command?

To perform one of these function on an index, table, or cluster:
  1. To collect statistics about object used by the optimizer and store them in the data dictionary.
  2. To delete statistics about the object used by object from the data dictionary.
  3. To validate the structure of the object.
  4. To identify migrated and chained rows of the table or cluster.

No comments:

Post a Comment