Enhanced subquery optimizations in Oracle

Proceedings of the VLDB Endowment

Volumn 2, Issue 2, 2009, Pages 1366-1377

  Bellamkonda, Srikanth ^a   Amor, Angela ^a   Ahmed, Rafi ^a   Zait, Mohamed ^a   Witkowsk, Andrew ^a   Lin, Chun Chieh ^a  

^a ORACLE CORPORATION   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

FLOCCULATION; QUERY PROCESSING;

OPTIMAL FORMS; PARALLEL EXECUTIONS; QUERY STRUCTURES; SUB-QUERIES; UNIVERSAL QUANTIFIERS; WINDOW FUNCTIONS;

RELATIONAL DATABASE SYSTEMS;

EID: 79957575073     PISSN: None     EISSN: 21508097     Source Type: Conference Proceeding    
DOI: 10.14778/1687553.1687563     Document Type: Article

References (15)

1. W. Kim. "On Optimizing an SQL-Like Nested Query", ACM TODS, September 1982.
2. U. Dayal, "Of Nests and Trees: A Unified Approach to Processing Queries that Contain Nested Subqueries, Aggregates, and Quantifiers", Proceedings of the 13 th VLDB Conference, Brighton, U.K., 1987.
3. M. Muralikrishna, "Improved Unnesting Algorithms for Join Aggregate SQL Queries", Proceedings of the 18th VLDB Conference, Vancouver, Canada, 1992.
4. H. Pirahesh, J.M. Hellerstein, and W. Hasan, "Extensible Rule Based Query Rewrite Optimizations in Starburst". Proc. ofACMSIGMOD, San Diego, U.S.A., 1992.
5. S. Chaudhuri and K. Shim, "Including Group-By in Query Optimization", Proceedings of the 20th VLDB Conference, Santiago, Chile, 1994.
6. W.P. Yan and A.P. Larson, "Eager Aggregation and Lazy Aggregation", Proceedings of the 21th VLDB Conference, Zurich, Switzerland, 1995.
7. A. Witkowski, et al, "Spreadsheets in RDBMS for OLAP", Proceedings of ACM SIGMOD, San Diego, USA, 2003.
8. R. Ahmed, et al, "Cost-Based Query Transformation in Oracle", Proceedings of the 3 2nd VLDB Conference, Seoul, S. Korea, 2006.
9. M. Elhemali, C. Galindo-Legaria, et al, "Execution Strategies for SQL Subqueries", Proceedings of ACM SIGMOD, Beijing, China, 2007.
10. A. Eisenberg, K. Kulkarni, et al, "SQL: 2003 Has Been Published", SIGMOD Record, March 2004.
11. F. Zemke. "Rank, Moving and reporting functions for OLAP," 99/01/22 proposal for ANSI-NCITS.
12. C. Zuzarte et al, "Method for Aggregation Subquery Join Elimination", http://www.freepatentsonline.com/7454416.html
13. C. Zuzarte, H. Pirahesh, et al, "WinMagic: Subquery Elimination Using Window Aggregation", Proceedings of ACM SIGMOD, San Diego, USA, 2003.
14. TPC Benchmark H (Decision Support), Standard Specification Rev 2.8, http://tpc.org/tpch/spec/tpch2.8.0.pdf
15. TPC-DS Specification Draft, Rev 32, http://www.tpc.org/tpcds/spec/tpcds32.pdf