We're sorry but this page doesn't work properly without JavaScript enabled. Please enable it to continue.
Feedback

Histogram support in MySQL 8.0

Logo of FOSDEM VZWFOSDEM VZW
 Grøvlen, Øystein

Formal Metadata

Title
Histogram support in MySQL 8.0
Title of Series
Number of Parts
644
Author
License
CC Attribution 2.0 Belgium:
You are free to use, adapt and copy, distribute and transmit the work or content in adapted or unchanged form for any legal purpose as long as the work is attributed to the author in the manner specified by the author or licensor.
Identifiers
Publisher
Release Date
Language

Content Metadata

Subject Area
Genre
Abstract
In MySQL 8.0, you can create histograms over column values. Histograms will improve the selectivity estimates used by the query optimizer, especially for conditions on columns that are not indexed. This presentation will cover the types of histograms you can create, and discuss best practices for using histograms. The presentation will contain many practical examples of how histograms improve query execution plans.