×
DuckDB Optimizer

DuckDB Internals - Part 7: Join Reordering Optimization

This article explains the Join Reorder optimization algorithm used by DuckDB.

DuckDB Internals - Part 6: DuckDB LocalStorage

This article explains how DuckDB’s LocalStorage efficiently handles INSERT operations within transactions using a shadow-table design and optimistic merging for bulk data.

DuckDB Internals - Part 5: The Transaction Lifecycle

This article focuses on the start, commit, and rollback of a transaction from the perspective of its lifecycle.

DuckDB Internals - Part 4: Optimizer Overview

This article will focus on explaining the purpose of all optimization rules implemented in DuckDB.

DuckDB Internals - Part 3: Execution Layer Overview

This article introduce the main concepts involved in each module of the execution layer, giving readers a general understanding of what each module does.