How to use histograms to get better performance

Speakers
  • Sergei Petrunia, Senior Software Engineer at MariaDB
  • Varun Gupta, Software Engineer at MariaDB
Session Abstract

Sergei Petrunia and Varun Gupta, software engineers MariaDB, show how histograms can be used to improve query performance. They begin by introducing histrograms and explaining why they’re needed by the query optimizer. Next, they discuss how to determine whether or not histrograms are needed, and if so, how to determine which tables and columns they should be applied. Finally, they cover best practices and recent improvements to histograms.

View Presentation Slides