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: 11055
Venue: VLDB
Year: 2015
Pagerank: 5.6400929e-05
Overall Rank: 5,186 | 63.93%
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,416	LeCo: Lightweight Compression via Learning Serial Correlations	2024	SIGMOD	7.1196234e-05
4,128	Are Updatable Learned Indexes Ready?	2022	VLDB	6.4292373e-05
4,152	openGauss: An Autonomous Database System	2021	VLDB	6.4060406e-05
5,194	Bitvector-aware Query Optimization for Decision Support Queries	2020	SIGMOD	5.6368209e-05
5,301	ReCache: Reactive Caching for Fast Analytics over Heterogeneous Data	2018	VLDB	5.5790928e-05
5,633	Analyzing the Impact of Cardinality Estimation on Execution Plans in Microsoft SQL Server	2023	VLDB	5.4011156e-05
7,335	MorphStore: Analytical Query Engine with a Holistic Compression-Enabled Processing Model	2020	VLDB	4.7603723e-05
8,502	Conditional Cuckoo Filters	2021	SIGMOD	4.4972336e-05
9,189	Including Bloom Filters in Bottom-up Optimization	2025	SIGMOD	4.3769978e-05
9,899	Accelerating Analytics with Dynamic In-Memory Expressions	2016	VLDB	4.2600049e-05
11,091	Grouping, Subsumption, and Disjunctive Join Optimizations in Oracle	2024	VLDB	4.1945683e-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
21	C-Store: A Column-oriented DBMS	2005	VLDB	0.00086087497
87	Hekaton: SQL Server’s Memory-Optimized OLTP Engine	2013	SIGMOD	0.00052389723
137	H-Store: A High-Performance, Distributed Main Memory Transaction Processing System	2008	VLDB	0.00042342967
241	DB2 with BLU Acceleration: So Much More than Just a Column Store	2013	VLDB	0.00031420034
310	The Vertica Analytic Database: C-Store 7 Years Later	2012	VLDB	0.00028132402
596	HYRISE—A Main Memory Hybrid Storage Engine	2011	VLDB	0.00019481482
1,795	MonetDB/XQuery: A Fast XQuery Processor Powered by a Relational Engine	2006	SIGMOD	0.00010526672
2,777	The Oracle Universal Server Buffer Manager	1997	VLDB	8.132433e-05
4,266	Parallel SQL Execution in Oracle 10g	2004	SIGMOD	6.30862e-05
7,415	Efficient and Scalable Statistics Gathering for Large Databases in Oracle 11g	2008	SIGMOD	4.7355557e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
454	An Overview of Query Optimization in Relational Systems	1998	PODS	0.00022734812
4,891	Distributed Architecture of Oracle Database In-memory	2015	VLDB	5.8516672e-05
3,154	The MemSQL Query Optimizer: A modern optimizer for real-time analytics in a distributed database	2016	VLDB	7.4686089e-05
2,504	Enhanced Subquery Optimizations in Oracle	2009	VLDB	8.6351917e-05
6,337	Parallelizing Extensible Query Optimizers	2009	SIGMOD	5.1053757e-05
710	Performance Tradeoffs in Read-Optimized Databases	2006	VLDB	0.00017765454
1,810	SQL Memory Management in Oracle9i	2002	VLDB	0.0001047003
6,374	Optimization of Conjunctive Predicates for Main Memory Column Stores	2016	VLDB	5.0927058e-05
11,091	Grouping, Subsumption, and Disjunctive Join Optimizations in Oracle	2024	VLDB	4.1945683e-05
4,571	Adaptive Statistics in Oracle 12c	2017	VLDB	6.0773174e-05