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.6328993e-05 |
| 10,404 | Dynamic Pruning for Recursive Joins | 2025 | SIGMOD | 4.1945683e-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,991 | Decidability and Undecidability Results for Boundedness of Linear Recursive Queries | 1988 | PODS | 9.84713e-05 |
| 4,732 | Handling Redundancy in the Processing of Recursive Database Queries | 1987 | SIGMOD | 5.9639609e-05 |
| 6,236 | Inherent Complexity of Recursive Queries (Extended Abstract) | 1999 | PODS | 5.1436959e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 1,529 | Evaluation Of Database Recursive Logic Programs As Recurrent Function Series | 1986 | SIGMOD | 0.00011496686 |
| 10,404 | Dynamic Pruning for Recursive Joins | 2025 | SIGMOD | 4.1945683e-05 |
| 4,732 | Handling Redundancy in the Processing of Recursive Database Queries | 1987 | SIGMOD | 5.9639609e-05 |
| 7,793 | Optimization of Object-Oriented Recursive Queries using Cost-Controlled Strategies | 1992 | SIGMOD | 4.6489537e-05 |
| 5,259 | On the Optimization of Recursive Relational Queries: Application to Graph Queries | 2020 | SIGMOD | 5.5984356e-05 |
| 130 | Optimization of Nested SQL Queries Revisited | 1987 | SIGMOD | 0.00044031247 |
| 2,110 | A Recursive Algebra and Query Optimization for Nested Relations | 1989 | SIGMOD | 9.5315487e-05 |
| 12,962 | Classification Of Recursive Formulas In Deductive Databases | 1988 | SIGMOD | 4.1945683e-05 |
| 143 | Optimization of Nonrecursive Queries | 1986 | VLDB | 0.00041510555 |
| 3,999 | EFFICIENT EVALUATION FOR A SUBSET OF RECURSIVE QUERIES (Extended Abstract) | 1987 | PODS | 6.5469939e-05 |