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


Discussion

No Comment Found

Related InterviewSolutions