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,296 | FlowLog: Efficient and Extensible Datalog via Incrementality | 2026 | VLDB | 4.1905499e-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.00036529607 |
| 982 | The POSTGRES Data Model | 1987 | VLDB | 0.00014865769 |
| 2,922 | RaSQL: Greater Power and Performance for Big Data Analytics with Recursive-aggregate-SQL on Spark | 2019 | SIGMOD | 7.897179e-05 |
| 3,670 | The LDBC Social Network Benchmark: Business Intelligence Workload | 2023 | VLDB | 6.8557811e-05 |
| 5,915 | Runtime-Extensible Parsers | 2025 | CIDR | 5.2696476e-05 |
| 9,699 | A Fix for the Fixation on Fixpoints | 2023 | CIDR | 4.2972307e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 11,056 | Efficient Enumeration of Recursive Plans in Transformation-based Query Optimizers | 2024 | VLDB | 4.1905499e-05 |
| 7,122 | Debunking the Myth of Join Ordering: Toward Robust SQL Analytics | 2025 | SIGMOD | 4.8199209e-05 |
| 10,241 | Robust Predicate Transfer with Dynamic Execution | 2026 | VLDB | 4.1905499e-05 |
| 12,972 | Classification Of Recursive Formulas In Deductive Databases | 1988 | SIGMOD | 4.1905499e-05 |
| 6,605 | MotherDuck: DuckDB in the cloud and in the client | 2024 | CIDR | 4.9923144e-05 |
| 10,384 | Data Chunk Compaction in Vectorized Execution | 2025 | SIGMOD | 4.1905499e-05 |
| 185 | DuckDB: an Embeddable Analytical Database | 2019 | SIGMOD | 0.00036529607 |
| 9,110 | Optimizing Recursive Queries in SQL | 2005 | SIGMOD | 4.3900304e-05 |
| 8,271 | Adaptive Factorization Using Linear-Chained Hash Tables | 2025 | CIDR | 4.539672e-05 |
| 8,257 | DuckPGQ: Efficient Property Graph Queries in an analytical RDBMS | 2023 | CIDR | 4.5437589e-05 |