Slow query? Add an index or two! But things are suddenly even slower! Indexes are great tools to speed data lookup but have overhead issues. Histograms don’t have that overhead but may not be suited. And how you lock rows also effects performance. So what do you do to speed up queries smartly? This is a clear, detailed look at what you can do to really speed up your queries in a logical, orthogonal process.

Comments

Comments are closed.

Anthony Tyler at 11:49 on 20 Oct 2021

Great talk, learned a good deal. Speaker was able to make an extremely dry subject and make it pretty interesting sometimes by making jokes about the dryness of the subject. I was entertained and learned some stuff, so mission accomplished.