Database Administrator (DBA) Question:

Download Job Interview Questions and Answers PDF

What is the use of ANALYZE command?

Database Administrator (DBA) Interview Question
Database Administrator (DBA) Interview Question

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.

Download Database Administrator (DBA) Interview Questions And Answers PDF

Previous QuestionNext Question
What is a Database instance?What is default tablespace?