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

–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.


Discussion

No Comment Found

Related InterviewSolutions