One Loop Does Not Fit All

Summary: Examines JIT-compiled queries in modern in-memory column-stores and questions the one-loop-for-all paradigm. Per-column selectivity dictates code layout: no-branch multi-loops help at low selectivity, while a single tight loop wins at higher selectivity. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 5092
Venue: SIGMOD
Year: 2015
Pagerank: 4.4507369e-05
Overall Rank: 8,791 | 38.85%
DOI: 10.1145/2723372.2764944

Incoming Non-self Citations Over Time

Authors

1. Styliani Pantela
2. Stratos Idreos

Incoming Citations (Sorted by Pagerank)

Showing 1 of 1 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
1,864	Relaxed Operator Fusion for In-Memory Databases: Making Compilation, Vectorization, and Prefetching Work Together At Last	2018	VLDB	0.00010280966

Outgoing Citations (Sorted by Pagerank)

Showing 3 of 3 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
60	Efficiently Compiling Efficient Query Plans for Modern Hardware	2011	VLDB	0.00064439773
408	Database Cracking	2007	CIDR	0.00023953844
4,376	Just-in-time compilation for SQL query processing	2013	VLDB	6.2424797e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
9,857	Towards Unifying Query Interpretation and Compilation	2023	CIDR	4.269353e-05
5,530	Permutable Compiled Queries: Dynamically Adapting Compiled Queries without Recompiling	2021	VLDB	5.4554282e-05
4,261	Parallelizing Query Optimization	2008	VLDB	6.31244e-05
11,850	Vectorizing an In Situ Query Engine	2016	SIGMOD	4.1945683e-05
9,625	Optimization of Disjunctive Predicates for Main Memory Column Stores	2017	SIGMOD	4.3157275e-05
60	Efficiently Compiling Efficient Query Plans for Modern Hardware	2011	VLDB	0.00064439773
1,864	Relaxed Operator Fusion for In-Memory Databases: Making Compilation, Vectorization, and Prefetching Work Together At Last	2018	VLDB	0.00010280966
4,376	Just-in-time compilation for SQL query processing	2013	VLDB	6.2424797e-05
6,374	Optimization of Conjunctive Predicates for Main Memory Column Stores	2016	VLDB	5.0927058e-05
853	Everything You Always Wanted to Know About Compiled and Vectorized Queries But Were Afraid to Ask	2018	VLDB	0.00015940507