Explain What is the use of ANALYZE command?

Submitted by: Administrator
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.
Submitted by: Administrator

Read Online Oracle Security Job Interview Questions And Answers