Adaptive Optimizations of Recursive Queries in Teradata

Summary: Adaptive optimization for Teradata recursive queries. Proposes a hybrid of multi-iteration pre-planning and dynamic feedback, avoiding static plans and full-feedback costs, enabling inter-iteration optimization for ANSI SQL recursive queries. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 4609
Venue: SIGMOD
Year: 2012
Pagerank: 4.6328993e-05
Overall Rank: 7,863 | 45.30%
DOI: -

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 2 of 2 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
3,988	All-in-One: Graph Processing in RDBMSs Revisited	2017	SIGMOD	6.5589605e-05
4,696	Asynchronous and Fault-Tolerant Recursive Datalog Evaluation in Shared-Nothing Engines	2015	VLDB	5.9911301e-05

Outgoing Citations (Sorted by Pagerank)

Showing 15 of 15 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
179	Efficient and Extensible Algorithms for Multi Query Optimization	2000	SIGMOD	0.00037672155
220	Efficient Mid-Query Re-Optimization of Sub-Optimal Query Execution Plans	1998	SIGMOD	0.00033194808
252	Adaptive Selectivity Estimation Using Query Feedback	1994	SIGMOD	0.00030632263
279	3-HOP: A High-Compression Indexing Scheme for Reachability Query	2009	SIGMOD	0.00029113513
334	Fast and Practical Indexing and Querying of Very Large Graphs	2007	SIGMOD	0.00027081079
376	TEDI: Efficient Shortest Path Query Answering on Graphs	2010	SIGMOD	0.00025097452
506	On Graph Query Optimization in Large Networks	2010	VLDB	0.00021475362
650	Robust Query Processing through Progressive Optimization	2004	SIGMOD	0.00018659177
688	Estimating the Size of Generalized Transitive Closures	1989	VLDB	0.00018134733
788	Efficiently Answering Reachability Queries on Very Large Directed Graphs	2008	SIGMOD	0.00016650034
919	Distance-Join: Pattern Match Query In a Large Graph Database	2009	VLDB	0.00015343179
977	Pipelining in Multi-Query Optimization	2001	PODS	0.0001488881
1,272	Proactive Re-Optimization	2005	SIGMOD	0.00012920076
1,355	SQL/MapReduce: A practical approach to self-describing, polymorphic, and parallelizable user-defined functions	2009	VLDB	0.00012404572
9,112	Optimizing Recursive Queries in SQL	2005	SIGMOD	4.3942347e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
4,732	Handling Redundancy in the Processing of Recursive Database Queries	1987	SIGMOD	5.9639609e-05
5,014	Dynamically Optimizing Queries over Large Scale Data Platforms	2014	SIGMOD	5.7586174e-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
1,529	Evaluation Of Database Recursive Logic Programs As Recurrent Function Series	1986	SIGMOD	0.00011496686
2,110	A Recursive Algebra and Query Optimization for Nested Relations	1989	SIGMOD	9.5315487e-05
143	Optimization of Nonrecursive Queries	1986	VLDB	0.00041510555
5,727	Enabling Incremental Query Re-Optimization	2016	SIGMOD	5.3510544e-05
9,112	Optimizing Recursive Queries in SQL	2005	SIGMOD	4.3942347e-05
11,053	Efficient Enumeration of Recursive Plans in Transformation-based Query Optimizers	2024	VLDB	4.1945683e-05