1Z0-908: MySQL 8.0 Database AdministratorDemo

Question

Review the following statement and its output:

Question Image

Which two statements about the histogram are true?

Choose two

A It is used to filter the rows in the world.city table.
B It improves the index statistics on the Population column.
C It is used by the optimizer to improve the join order.
D It is created using 64 random dives into the world.city table.
E It contains statistics for the number of distinct values in the Population column.
F It provides information about the frequency of the Population values.

Explanation

MySQL histogram buckets describe the distribution of a column’s values. They record cumulative frequencies, and equi-height buckets include the count of distinct values within each bucket range. Therefore, the histogram provides frequency information for Population values and distinct-value statistics.

Learn more

MySQL Reference Manual: Optimizer Statistics

1Z0-908: MySQL 8.0 Database AdministratorDemo

AstroTutor

Notes

Readiness

QuestionQ157

Community Discussion