Home » Interview » Technology

What is the use of ANALYZE command?

Correct 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→

Discussion & Comments

No comments yet. Be the first to comment!
Join Discussion