Glossary

HISTOGRAM NUMQUANTILES 100

Collects histogram statistics with 100 quantile divisions. Histograms provide the optimizer with data distribution information beyond simple min/max values. They reveal clusters, gaps, and skew patterns that dramatically improve range predicate estimation.

Learn More

Related Terms