DEVFYI - Developer Resource - FYI

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