- To collect statistics about object used by the optimizer and store them in the data dictionary.
- To delete statistics about the object used by object from the data dictionary.
- To validate the structure of the object.
- To identify migrated and chained rows of the table or cluster.
Tuesday, March 19, 2013
What is the use of ANALYZE command?
To perform one of these function on an index, table, or cluster: