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.
OPEN TALK: Indexes vs. Histograms to Speed Up Database Searches
Dave Stokes is a MySQL Community Manager for Oracle. He has worked for organizations ranging alphabetically from the American Heart Association to Xerox in areas ranging from anti-submarine warfare to webmaster. He lives in a small Texas town with the required hound dog and pickup truck. And Dave is the Author of MySQL & JSON - A Practical Programming Guide now in a second edition