This “Analyze” command is used to perform various functions on index, table, or cluster. The following list specifies the usage of ANALYZE command in Oracle:
Analyze command is used to identify migrated and chained rows of the table or a cluster.
It is used to validate the structure of an object.
This helps in collecting the statistics about the object used by the user and are then stored on to the data dictionary.
It also helps in deleting statistics that are used by an object from the data dictionary.
