| |||||
 |
|
|
|||
|
|
What is the use of ANALYZE command? More DBA job interview questions and answers at
http://dba.fyicenter.com/Interview-Questions/
(Continued from previous question...) 201. What is the use of ANALYZE command? 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. (Continued on next question...)
Other Job Interview Questions
|
||||
|
|
|
|||
