Things Every Developer Absolutely, Positively Needs to Know About Database Indexing - Kai Sassnowski

Kai is an active member of the Laravel community and the author of several open source projects such as Laravel Venture and Roach, the complete web scraping toolkit for PHP.

This talk dives deep into a topic that I believe developers don't know enough about: database indexing. Nothing can kill application performance quite like slow database queries.

We will cover the data structure behind the most common type of index and how it affects the behaviour of an index. After that, we will take a look at the different ways a database can use an index to execute different queries. To do so, we also have to learn how to access and understand the execution plan for a given query.

📹 Recorded from the following event: https://www.meetup.com/laravel-switze...
🐦 Kai's Twitter:   / warsh33p