What is the use of ANALYZE command ?

Answer Posted / guest

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.

Is This Answer Correct ?    4 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

No New Questions to Answer in this Category !!    You can

Post New Questions

Answer Questions in Different Category