php[tek] 2023 php[tek] 2023 Login
MySQL Indexes -- How They Really Work
Speaker: Dave Stokes
MySQL Indexes -- How They Really Work

Level: Intermediate (some prior knowledge necessary)
Length: Standard Session (45-60 minutes)

Description:
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.

Thanks to our php[tek] 2025 sponsors!
PHP Architect
(Platinum)