WWhat is the use of ANALYZE command ?
ORACLE Interview Questions and Answers (Part 1)
(Continued from previous question...)
71. WWhat is the use of ANALYZE command ?
To perform one of these function on an index,table, or cluster:
- 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.
(Continued on next question...)
Other Interview Questions