Thursday, November 18, 2021

OPEN TALK: Indexes vs. Histograms to Speed Up Database Searches
Join on Hopin
Dave Stokes
Dave Stokes
Oracle, MySQL Community Manager

Nobody complains that the database is too fast. But when things slow down they do complain. The two most popular ways of speeding up queries in a relational database are indexes and histograms, This talks covers when to use one over the other, how to properly construct an index, where histograms fail, and much more.