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: www.meetup.com...
🐦 Kai's Twitter: / warsh33p

[@JOHNSMITH-ve3rq]

Insanely educational. Just wow. Not sure I’ve learnt so much about databases so quickly.

[@swiss-laravel-association]

Glad you liked it. 😊

[@kurshadqaya1684]

Man I have been in development since 2015, just memorized some rules about indexes, but never understood until I watched this video. Thank you very much for explaining like I am 5 years old.

[@swiss-laravel-association]

Glad you liked it. Kai has a real gift to explain complex things. 😊

[@gabrielalvescunha9405]

This deserves so much more views :D

[@swiss-laravel-association]

That's true. Kai his knowledge about databases is insane. Just 🔥

[@ChrisHansonDev]

Really enjoyed this video. Came up after another video and watched the whole thing, extremely interesting talk. Thanks

[@swiss-laravel-association]

Awesome. Really glad you liked it, Chris. Kai is a great educator. 🤓

[@stormShadow64]

Awesome video, very useful

[@swiss-laravel-association]

Glad you liked it. Kai is an absolute a pro in explaining complex topics. 🙏

[@johnw.8782]

Great video. Shared.

[@swiss-laravel-association]

Thanks for that! 😊

[@jesenialimited1385]

Great talk, but I would have loved to seen some more complex examples, for e.g. how can index help when you have to use joins, what about functional indexes etc...

[@swiss-laravel-association]

Thank you. Kai did a fantastic introduction talk to database indexing. Planet Scale does offer more in depth courses. Check it out here: planetscale.com/learn/courses/mysql-for-developers/introduction/course-introduction Hope this can help you out. 🙏

[@animeshsahu2803]

Your Laracon EU talk was way better tbh (ngl).

[@swiss-laravel-association]

I appreciate your feedback! Did you enjoy it? 😊

[@SebastienMaviel]

Is there slides pdf for this ?

[@swiss-laravel-association]

Unfortunately no slides are provided. Other than that how‘d you like the talk?

[@SebastienMaviel]

@@swiss-laravel-association Loved it ! Really insightful, especially the composite index part. Also really liked the visuals that made it lot more easy to understand those concepts :)