DB Internals Explained

For developers who write SQL

The parts of a database you never see — explained.

Indexes, joins, the query optimizer, execution plans. Four concepts that decide whether your query takes 2 ms or 2 minutes. Learn how each one works, and how it differs across the engines you actually use.

Databases covered