Query Optimization in Oracle 12c Database In-Memory

Summary: Oracle 12c Database In-Memory implements a dual-format engine (row-major on-disk + in-memory columnar), requiring format-aware optimization. A holistic optimizer redesign covers statistics, cost models, transformations, access paths, and joins to exploit both formats under varying workloads. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 11056
Venue: VLDB
Year: 2015
Pagerank: 5.6360141e-05
Overall Rank: 5,184 | 63.98%
DOI: -

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 11 of 11 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
3,419	LeCo: Lightweight Compression via Learning Serial Correlations	2024	SIGMOD	7.1127752e-05
4,056	Are Updatable Learned Indexes Ready?	2022	VLDB	6.4905689e-05
4,151	openGauss: An Autonomous Database System	2021	VLDB	6.4020605e-05
5,195	Bitvector-aware Query Optimization for Decision Support Queries	2020	SIGMOD	5.6314278e-05
5,304	ReCache: Reactive Caching for Fast Analytics over Heterogeneous Data	2018	VLDB	5.5738777e-05
5,639	Analyzing the Impact of Cardinality Estimation on Execution Plans in Microsoft SQL Server	2023	VLDB	5.3972261e-05
7,331	MorphStore: Analytical Query Engine with a Holistic Compression-Enabled Processing Model	2020	VLDB	4.7558046e-05
8,499	Conditional Cuckoo Filters	2021	SIGMOD	4.4929219e-05
9,193	Including Bloom Filters in Bottom-up Optimization	2025	SIGMOD	4.372803e-05
9,898	Accelerating Analytics with Dynamic In-Memory Expressions	2016	VLDB	4.2559233e-05
11,094	Grouping, Subsumption, and Disjunctive Join Optimizations in Oracle	2024	VLDB	4.1905499e-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
20	C-Store: A Column-oriented DBMS	2005	VLDB	0.00086163998
87	Hekaton: SQL Server’s Memory-Optimized OLTP Engine	2013	SIGMOD	0.00052844656
136	H-Store: A High-Performance, Distributed Main Memory Transaction Processing System	2008	VLDB	0.00042409816
241	DB2 with BLU Acceleration: So Much More than Just a Column Store	2013	VLDB	0.00031314629
310	The Vertica Analytic Database: C-Store 7 Years Later	2012	VLDB	0.0002815547
594	HYRISE—A Main Memory Hybrid Storage Engine	2011	VLDB	0.00019515008
1,787	MonetDB/XQuery: A Fast XQuery Processor Powered by a Relational Engine	2006	SIGMOD	0.00010543821
2,793	The Oracle Universal Server Buffer Manager	1997	VLDB	8.1179265e-05
4,260	Parallel SQL Execution in Oracle 10g	2004	SIGMOD	6.3033486e-05
7,414	Efficient and Scalable Statistics Gathering for Large Databases in Oracle 11g	2008	SIGMOD	4.7312542e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
454	An Overview of Query Optimization in Relational Systems	1998	PODS	0.00022796106
4,887	Distributed Architecture of Oracle Database In-memory	2015	VLDB	5.8498783e-05
3,150	The MemSQL Query Optimizer: A modern optimizer for real-time analytics in a distributed database	2016	VLDB	7.4765759e-05
2,503	Enhanced Subquery Optimizations in Oracle	2009	VLDB	8.6306662e-05
6,333	Parallelizing Extensible Query Optimizers	2009	SIGMOD	5.1013149e-05
708	Performance Tradeoffs in Read-Optimized Databases	2006	VLDB	0.00017753572
1,810	SQL Memory Management in Oracle9i	2002	VLDB	0.00010471365
6,372	Optimization of Conjunctive Predicates for Main Memory Column Stores	2016	VLDB	5.0878306e-05
11,094	Grouping, Subsumption, and Disjunctive Join Optimizations in Oracle	2024	VLDB	4.1905499e-05
4,566	Adaptive Statistics in Oracle 12c	2017	VLDB	6.073045e-05