What is the use of analyze command?

Posted by silpa on Sep 11 2007

analyze command is used on index,table or cluster

used to collect statistics about object and store them in data dictionary

used to delete statistics about object from data dictionary

validate structure of the object

Leave a Comment