Systems | Development | Analytics | API | Testing

Fivetran

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.