Optimizing Recursive Queries in SQL
Summary: Optimizes linear recursive SQL queries (transitive closure) via three techniques: early selection evaluation, elimination of duplicates in intermediates, and a specialized index for joins. Evaluations on binary trees and sparse graphs show notable reductions in recursive query time for graph workloads. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
Incoming Citations (Sorted by Pagerank)
Showing 2 of 2 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 7,863 | Adaptive Optimizations of Recursive Queries in Teradata | 2012 | SIGMOD | 4.628688e-05 |
| 10,415 | Dynamic Pruning for Recursive Joins | 2025 | SIGMOD | 4.1905499e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 3 of 3 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 1,997 | Decidability and Undecidability Results for Boundedness of Linear Recursive Queries | 1988 | PODS | 9.837483e-05 |
| 4,479 | Handling Redundancy in the Processing of Recursive Database Queries | 1987 | SIGMOD | 6.1439609e-05 |
| 6,234 | Inherent Complexity of Recursive Queries (Extended Abstract) | 1999 | PODS | 5.1387584e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 1,552 | Evaluation Of Database Recursive Logic Programs As Recurrent Function Series | 1986 | SIGMOD | 0.00011393892 |
| 10,415 | Dynamic Pruning for Recursive Joins | 2025 | SIGMOD | 4.1905499e-05 |
| 4,479 | Handling Redundancy in the Processing of Recursive Database Queries | 1987 | SIGMOD | 6.1439609e-05 |
| 7,794 | Optimization of Object-Oriented Recursive Queries using Cost-Controlled Strategies | 1992 | SIGMOD | 4.6446441e-05 |
| 5,267 | On the Optimization of Recursive Relational Queries: Application to Graph Queries | 2020 | SIGMOD | 5.5930569e-05 |
| 130 | Optimization of Nested SQL Queries Revisited | 1987 | SIGMOD | 0.00044001626 |
| 2,109 | A Recursive Algebra and Query Optimization for Nested Relations | 1989 | SIGMOD | 9.5283567e-05 |
| 12,972 | Classification Of Recursive Formulas In Deductive Databases | 1988 | SIGMOD | 4.1905499e-05 |
| 144 | Optimization of Nonrecursive Queries | 1986 | VLDB | 0.00041430126 |
| 3,990 | EFFICIENT EVALUATION FOR A SUBSET OF RECURSIVE QUERIES (Extended Abstract) | 1987 | PODS | 6.5536618e-05 |