Library › PHP Tek 2023 › MySQL Indexes -- How They Really Work
MySQL Indexes -- How They Really Work

Log in to watch this talk

You need to be logged in to access this video. If you don't have an account, purchase a virtual pass for the latest php[tek] conference to get access to the full video library.

Log In Get a Virtual Pass

MySQL Indexes -- How They Really Work

Dave Stokes Dave Stokes PHP Tek 2023 Intermediate (some prior knowledge necessary) Standard (50 minutes)

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.

Up Next from PHP Tek 2023

Debugging Our Way Through PHP
Derick Rethans · Standard (50 minutes)
Filesystem Management with Flysystem
Mark Niebergall · Standard (50 minutes)
Build and Release Confidently with Continuous Integration and Delivery
Steve Grunwell · Standard (50 minutes)
API Design Patterns for the REST of Us
Ian Littman · Standard (50 minutes)