Database Administrator (DBA) Question:
What is the use of ANALYZE command?
Answer:
To perform one of these function on an index, table, or cluster: - To collect statistics 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 off the table or cluster.
| Previous Question | Next Question |
| What is a Database instance? | What is default tablespace? |