Indexing queries is simple engineering but many get confused by what to index, when to index, and why sometimes adding an index really s-l-o-w-s processing down. This session covers why you really need to designate your own primary key as the default picked by the server will not be helpful, how to see which index the query optimizer chooses, why the old rules about multi-column index are gone, and how optimizer hints can get you back on track. There is a lot of mythology about indexing MySQL tables and you will see how it is simple engineering to speed up your queries.


Comments are closed.

It’s Dave and databases (Davabases?), what more could you need? Lots of new-to-me details about getting the most out of MySQL.

Nick Marsceau at 17:21 on 17 May 2023

Dave really knows what he was talking about! There was a lot of information, but I took away several nuggets I expect to use to improve my company's databases in the near future.

Gary Pedretty at 09:08 on 18 May 2023

Great set of tools to really setup mySQL for best performance.

Brandon Worby at 15:32 on 18 May 2023

Super talk. Found it very informative.