Bas Steins

Camp Counselor

Understanding EXPLAIN statements

Event Logo

Tuesday, July 25, 2023 - 7:30 PM UTC, for 1 hour.

Regular, 60 minute presentation

Room: G

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.

Take Aways

  • Data Structures in RDBMs
  • Mechanics of Indices
  • How to leverage the EXPLAIN statement
favorited by:
Itagyba Kuhlmann Tim Kempster Kevin Moens Jason Cairol Bob Dankert Brian Meeker Jacob Netz Derek Mulhausen Brett Allenstein Matt Giuliani Kevin Kelchen Drew Douglas Dan Willman Timothy Tyson Nick Heidke Kevin Ziegler