Systems | Development | Analytics | API | Testing

September 2020

Databases Demystified Lesson 10: Query Planning and Optimization

In this lesson, we talk about what a query planner is and does in the database. We talk about the difference between declarative and imperative programming languages, and we wrap up with a discussion of some common strategies for database optimization to improve query speed.

Episode 9: Introduction to Indexes

In this episode, we learn about a very important technique for making database queries faster: indexes! Indexes are a very powerful technique and are critical to understanding how databases work under the hood. In this lesson we talk about how database indexes make use of the binary search algorithm to speed up queries. We also cover the trade-offs associated with using database indexes, and why it might not be a good idea to use too many indexes.