Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scalable, and Maintainable Systems

by Martin Kleppmann

In a relational database, the query optimizer automatically decides which parts of the query to execute in which order, and which indexes to use.