This article explains the Join Reorder optimization algorithm used by DuckDB.
This article explains how DuckDB’s LocalStorage efficiently handles INSERT operations within transactions using a shadow-table design and optimistic merging for bulk data.
This article focuses on the start, commit, and rollback of a transaction from the perspective of its lifecycle.
