February 24-26, 2021
Online, Timezone GMT-5

MySQL Histograms versus Indexes

Nobody complains when the database is too fast. Those in search of ever faster queries will use indexed to speed them. But indexes have overhead and improper understanding of their technology can actually make things slower. Histograms are another technique that can be useful but they do not work for all types of data. This session will cover which to use when and help you understand why each has its place in the MySQL optimizer.

View all 130 sessions

Dave Stokes

Oracle

Dave Stokes is a MySQL Community Manager for Oracle. Previously he was the MySQL Certification Manager for MySQL AB and SUN. He has worked for companies ranging alphabetically from the American Heart Association to Xerox and work ranging from Anti-submarine warfare to web developer. He is the author of MySQL & JSON - A Practical Programming Guide, now in it is in its second edition

Read More

Comments

Please remain courteous and constructive. Comments will be moderated.

Online 2021 sponsored by