Indexes in Action: How to Speed Up Queries Without Breaking Everything
-
40 min
This talk focuses on optimising database queries and using indexes effectively. We’ll look at what to do when queries start slowing down, learn how to analyse query execution plans using the EXPLAIN and EXPLAIN ANALYZE commands, and explore how indexes impact performance.
Through both simple and complex examples, we’ll examine how to improve query efficiency, understand index selectivity, and avoid common mistakes that lead to performance issues.
We’ll conclude by discussing when it truly makes sense to use indexes—and how they can become a powerful tool for optimisation.