Answers

Question and Answer:

  Home  Database Administrator (DBA)

⟩ What 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 off the table or cluster.

 137 views

More Questions for you: