Performance Tuning - Question 090

What does this statement do?

SQL> ANALYZE INDEX index_name VALIDITY STRUCTURE;

A. It places information into the INDEX_STATS view and allows for the monitoring of space used by an index.

B. It provides information in the INDEX_HISTOGRAM view to indicate whether an index is invalid or valid.

C. It provides information in the DBA_INDEXES view for the COST BASED Optimizer when choosing an execution plan.

Answer: A

Explanation:

The VALIDATE STRUCTURE option for the ANALYZE command populates the data dictionary view INDEX_STATS with values.

Incorrect Answers

B: This command does not provide information in the INDEX_HISTOGRAM view.

C: This command does not provide information in the DBA_INDEX data dictionary view.

OCP: Oracle 9i Performance Tuning Study Guide, Joseph C. Johnson, p. 150

Chapter 3: SQL Application Tuning and Design