The ____ option of the ANALYZE command calculates statistics on a sample number or percentage of rows,defaulted to 1,064 rows.
A) ESTIMATE
B) SYSTEM
C) CALCULATE
D) COMPUTE

Question

Quizplus · Accepted Answer

The ESTIMATE option allows the user to specify the sample size for which statistics are to be estimated. This can help to save time and resources by not analyzing the entire dataset. The default value is 1,064 rows, but it can be changed to a specific number or percentage.

The ____ Option of the ANALYZE Command Calculates Statistics on a Sample