Understanding EXPLAIN statements
The relational database model is still one of the most prominent choices in modern applications to persist state. Nowadays, more often than not, the internals of our databases are hidden behind abstraction layers, such as ORMs. In this session, we will learn about the inner mechanics of databases and frequently under-used features of modern SQL. This will help us gain a better understanding and, thus, improve our queries and utilisation of tools. We will primarily focus on the EXPLAIN statement to better understand what's going on behind the scenes when performing queries.
- Data Structures in RDBMs
- Mechanics of Indices
- How to leverage the EXPLAIN statement