Query Optimization in Oracle 12c Database In-Memory

Summary: Oracle 12c’s dual-format engine needs plans tailored to row-major versus in-memory columnar scans; format-blind optimization can erase columnar gains. Redesign spans statistics, costing, transformations, joins, parallelism, and cluster awareness under dynamic constraints. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID: 11243
Venue: VLDB
Year: 2015
Pagerank: 6.7150543e-05
Overall Rank: 4,416 | 69.71%
DOI: 10.14778/2824032.2824038

Incoming Non-self Citations Over Time

Authors

1. Dinesh Das (Oracle)
2. Jiaqi Yan (Oracle)
3. Mohamed Zait (Oracle)
4. Satyanarayana R Valluri (EPFL)
5. Nirav Vyas (Oracle)
6. Ramarajan Krishnamachari (Oracle)
7. Prashant Gaharwar (Oracle)
8. Jesse Kamp (Oracle)
9. Niloy Mukherjee (Oracle)

BibTeX Citation

@article{das_vldb15,
        title = {{Query Optimization in Oracle 12c Database In-Memory}},
        author = {Das, Dinesh and Yan, Jiaqi and Zait, Mohamed and Valluri, Satyanarayana R and Vyas, Nirav and Krishnamachari, Ramarajan and Gaharwar, Prashant and Kamp, Jesse and Mukherjee, Niloy},
        journal = {PVLDB},
        series = {{VLDB} '15},
        volume = {8},
        number = {12},
        pages = {1770--1781},
        doi = {10.14778/2824032.2824038},
        url = {https://doi.org/10.14778/2824032.2824038},
        year = {2015}
}

Incoming Citations (Sorted by Pagerank)

Showing 12 of 12 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
2,806	Are Updatable Learned Indexes Ready?	2022	VLDB	8.1013097e-05
3,662	openGauss: An Autonomous Database System	2021	VLDB	7.2166682e-05
4,065	LeCo: Lightweight Compression via Learning Serial Correlations	2024	SIGMOD	6.930275e-05
4,764	ReCache: Reactive Caching for Fast Analytics over Heterogeneous Data	2018	VLDB	6.51896e-05
4,849	Bitvector-aware Query Optimization for Decision Support Queries	2020	SIGMOD	6.4803828e-05
5,010	Analyzing the Impact of Cardinality Estimation on Execution Plans in Microsoft SQL Server	2023	VLDB	6.4023732e-05
6,665	MorphStore: Analytical Query Engine with a Holistic Compression-Enabled Processing Model	2020	VLDB	5.8089595e-05
8,413	Conditional Cuckoo Filters	2021	SIGMOD	5.4306049e-05
9,279	Including Bloom Filters in Bottom-up Optimization	2025	SIGMOD	5.2934632e-05
10,053	Accelerating Analytics with Dynamic In-Memory Expressions	2016	VLDB	5.1685424e-05
10,260	L3: A GPU-Native Co-Designed Data Format for Learned Lossless Lightweight Compression	2026	SIGMOD	5.093636e-05
11,297	Grouping, Subsumption, and Disjunctive Join Optimizations in Oracle	2024	VLDB	5.093636e-05

Outgoing Citations (Sorted by Pagerank)

Showing 10 of 10 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
12	C-Store: A Column-oriented DBMS	2005	VLDB	0.00069513174
38	Hekaton: SQL Server’s Memory-Optimized OLTP Engine	2013	SIGMOD	0.00047648573
83	H-Store: A High-Performance, Distributed Main Memory Transaction Processing System	2008	VLDB	0.00036185259
165	DB2 with BLU Acceleration: So Much More than Just a Column Store	2013	VLDB	0.00027693424
186	The Vertica Analytic Database: C-Store 7 Years Later	2012	VLDB	0.00026182534
428	HYRISE—A Main Memory Hybrid Storage Engine	2011	VLDB	0.00018633493
1,460	MonetDB/XQuery: A Fast XQuery Processor Powered by a Relational Engine	2006	SIGMOD	0.00010710674
2,558	The Oracle Universal Server Buffer Manager	1997	VLDB	8.41572e-05
4,633	Parallel SQL Execution in Oracle 10g	2004	SIGMOD	6.5931076e-05
7,377	Efficient and Scalable Statistics Gathering for Large Databases in Oracle 11g	2008	SIGMOD	5.6297042e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	290	An Overview of Query Optimization in Relational Systems	1998	PODS
2	4,560	Distributed Architecture of Oracle Database In-memory	2015	VLDB
3	2,597	The MemSQL Query Optimizer: A modern optimizer for real-time analytics in a distributed database	2016	VLDB
4	2,095	Enhanced Subquery Optimizations in Oracle	2009	VLDB
5	6,026	Parallelizing Extensible Query Optimizers	2009	SIGMOD
6	630	Performance Tradeoffs in Read-Optimized Databases	2006	VLDB
7	1,706	SQL Memory Management in Oracle9i	2002	VLDB
8	6,009	Optimization of Conjunctive Predicates for Main Memory Column Stores	2016	VLDB
9	11,297	Grouping, Subsumption, and Disjunctive Join Optimizations in Oracle	2024	VLDB
10	4,277	Adaptive Statistics in Oracle 12c	2017	VLDB