How DuckDB is USING KEY to Unlock Recursive Query Performance
Summary: Investigates USING KEY variant of recursive CTEs in DuckDB, enabling overwriting of previous intermediate results. Shows production-ready integration that reduces union-table size and runtime, validated on LDBC graphs with an interactive demo. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Björn Bamberg
- 2. Denis Hirn
- 3. Torsten Grust
Incoming Citations (Sorted by Pagerank)
Showing 1 of 1 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 10,284 | FlowLog: Efficient and Extensible Datalog via Incrementality | 2026 | VLDB | 4.1945683e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 6 of 6 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 185 | DuckDB: an Embeddable Analytical Database | 2019 | SIGMOD | 0.00036538405 |
| 974 | The POSTGRES Data Model | 1987 | VLDB | 0.00014896625 |
| 2,919 | RaSQL: Greater Power and Performance for Big Data Analytics with Recursive-aggregate-SQL on Spark | 2019 | SIGMOD | 7.9047279e-05 |
| 3,668 | The LDBC Social Network Benchmark: Business Intelligence Workload | 2023 | VLDB | 6.8591612e-05 |
| 5,915 | Runtime-Extensible Parsers | 2025 | CIDR | 5.274713e-05 |
| 9,700 | A Fix for the Fixation on Fixpoints | 2023 | CIDR | 4.3013524e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 11,053 | Efficient Enumeration of Recursive Plans in Transformation-based Query Optimizers | 2024 | VLDB | 4.1945683e-05 |
| 7,126 | Debunking the Myth of Join Ordering: Toward Robust SQL Analytics | 2025 | SIGMOD | 4.8232367e-05 |
| 10,241 | Robust Predicate Transfer with Dynamic Execution | 2026 | VLDB | 4.1945683e-05 |
| 12,962 | Classification Of Recursive Formulas In Deductive Databases | 1988 | SIGMOD | 4.1945683e-05 |
| 6,604 | MotherDuck: DuckDB in the cloud and in the client | 2024 | CIDR | 4.9971118e-05 |
| 10,372 | Data Chunk Compaction in Vectorized Execution | 2025 | SIGMOD | 4.1945683e-05 |
| 185 | DuckDB: an Embeddable Analytical Database | 2019 | SIGMOD | 0.00036538405 |
| 9,112 | Optimizing Recursive Queries in SQL | 2005 | SIGMOD | 4.3942347e-05 |
| 8,275 | Adaptive Factorization Using Linear-Chained Hash Tables | 2025 | CIDR | 4.5439841e-05 |
| 8,276 | DuckPGQ: Efficient Property Graph Queries in an analytical RDBMS | 2023 | CIDR | 4.5439811e-05 |