The ____ option of the ANALYZE command collects only system statistics,not user schema statistics.
A) ESTIMATE
B) SYSTEM
C) CALCULATE
D) COMPUTE

Question

Quizplus · Accepted Answer

The SYSTEM option of the ANALYZE command collects only system statistics, which includes information about the distribution of data within a database. User schema statistics are not collected with this option. This option is useful for improving query optimization and performance. The other options (ESTIMATE, CALCULATE, and COMPUTE) are not relevant to this particular question.

The ____ Option of the ANALYZE Command Collects Only System