1.

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 of the table or cluster.

To perform one of these function on an index,table, or cluster:


Discussion

No Comment Found

Related InterviewSolutions