Oracle Security Question:
Download Questions PDF

Explain What is the use of ANALYZE command?

Answer:

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.

Download Oracle Security Interview Questions And Answers PDF

Previous QuestionNext Question
How to reduce the network traffic?How to specify the Archived log file name format and destination?