Answers

Question and Answer:

  Home  Oracle Security

⟩ Explain What is the use of ANALYZE command?

To perform one of these function on an index,table, or cluster:

- to collect statisties 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.

 197 views

More Questions for you: