The ANALYZE command in Oracle can be used to perform a number of functions on indexes, tables, or clusters. Some of the use cases of the ANALYZE command in Oracle are as follows:-
- The ANALYZE command can be used to find out migrated and chained rows of the table or cluster. Also, it can be used to validate the structure of the object.
- It helps in collecting the statistics about objects which the optimizer is using. After that, they are stored in the data dictionary.
- It helps in deleting statistics used by objects from the data dictionary.
