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.
