Good video series on DB indexes

owlmanatt

Programmer
Chris Fideloper released the first section of his new webcast series, Performant Laravel, this morning. Included was a really good introduction to indexing your database tables. If you're unfamiliar with this topic, I highly recommend giving these three videos a run through:

  1. https://serversforhackers.com/laravel-perf/mysql-indexing-one
  2. https://serversforhackers.com/laravel-perf/mysql-indexing-two
  3. https://serversforhackers.com/laravel-perf/mysql-indexing-three
While it is a series about Laravel, these concepts are useful even if you're using another framework, or no framework at all. He is demonstrating on MySQL, but indexes work the same in Postgres, MariaDB, MS SQL Server, etc.

 
Back
Top