ANALYZE
command is used to perform various functions on index, table, or cluster. The following list specifies the usage of ANALYZE
command in Oracle :
* It is used to validate the structure of the object.
* It is used to identify migrated and chained rows of the table or cluster.
* It helps in collecting the statistics about object used by the optimizer. They are then stored in the data dictionary.
* It helps in deleting statistics used by object from the data dictionary.