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: 5093
Venue: SIGMOD
Year: 2015
Pagerank: 4.4464764e-05
Overall Rank: 8,788 | 38.93%
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,865	Relaxed Operator Fusion for In-Memory Databases: Making Compilation, Vectorization, and Prefetching Work Together At Last	2018	VLDB	0.00010271333

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
59	Efficiently Compiling Efficient Query Plans for Modern Hardware	2011	VLDB	0.0006445664
407	Database Cracking	2007	CIDR	0.00023941779
4,373	Just-in-time compilation for SQL query processing	2013	VLDB	6.2365066e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
9,856	Towards Unifying Query Interpretation and Compilation	2023	CIDR	4.2652623e-05
5,540	Permutable Compiled Queries: Dynamically Adapting Compiled Queries without Recompiling	2021	VLDB	5.450319e-05
4,255	Parallelizing Query Optimization	2008	VLDB	6.3080082e-05
11,858	Vectorizing an In Situ Query Engine	2016	SIGMOD	4.1905499e-05
9,625	Optimization of Disjunctive Predicates for Main Memory Column Stores	2017	SIGMOD	4.3115918e-05
59	Efficiently Compiling Efficient Query Plans for Modern Hardware	2011	VLDB	0.0006445664
1,865	Relaxed Operator Fusion for In-Memory Databases: Making Compilation, Vectorization, and Prefetching Work Together At Last	2018	VLDB	0.00010271333
4,373	Just-in-time compilation for SQL query processing	2013	VLDB	6.2365066e-05
6,372	Optimization of Conjunctive Predicates for Main Memory Column Stores	2016	VLDB	5.0878306e-05
848	Everything You Always Wanted to Know About Compiled and Vectorized Queries But Were Afraid to Ask	2018	VLDB	0.00015933538