DBScholar

Back to papers

I Can't Believe It's Not Yannakakis: Pragmatic Bitmap Filters in Microsoft SQL Server

Summary: Shows Microsoft SQL Server’s bitmap pre-filtering plus pull-based execution and the Cascades optimizer effectively realizes Yannakakis-like, instance-optimal join behavior in practice. Exposes overlooked intermediate-result pre-filtering opportunities yielding near semi-robust plans and reframes industrial optimizations as a rich research agenda. (summarized by gpt-5-mini on Feb 09 2026)

Paper ID
h5ce503d55ecff7aa
Venue
CIDR
Year
2026
Pagerank
4.9793485e-05
Overall Rank
10,356 | 30.38%
DOI
-

Incoming Non-self Citations Over Time

No non-self incoming citations found for this paper in this database.

Authors

BibTeX Citation

@inproceedings{zhao_cidr26,
        address = {Amsterdam, Netherlands},
        series = {{CIDR} '26},
        title = {{I Can't Believe It's Not Yannakakis: Pragmatic Bitmap Filters in Microsoft SQL Server}},
        booktitle = {Proceedings of the {Conference} on {Innovative} {Data} {Systems} {Research}},
        author = {Zhao, Hangdong and Tian, Yuanyuan and Alotaibi, Rana and Ding, Bailu and Bruno, Nicolas and Camacho-Rodríguez, Jesús and Papadimos, Vassilis and Juárez, Ernesto Cervantes and Galindo-Legaria, Cesar and Curino, Carlo},
        year = {2026}
}

Incoming Citations (Sorted by Pagerank)

Showing 0 of 0 citing papers.

Rank Citing Paper Year Venue Pagerank
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 30 of 30 cited papers.

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

Rank Cited Paper Year Venue Pagerank
14 MonetDB/X100: Hyper-Pipelining Query Execution 2005 CIDR 0.00064031282
15 How Good Are Query Optimizers, Really? 2016 VLDB 0.00061066921
208 EmptyHeaded: A Relational Engine for Graph Processing 2016 SIGMOD 0.00024884544
315 Worst-Case Optimal Join Algorithms: Techniques, Results, and Open Problems 2018 PODS 0.00021246
891 SuRF: Practical Range Query Filtering with Fast Succinct Tries 2018 SIGMOD 0.00013245926
1,766 SQL Server Column Store Indexes 2011 SIGMOD 9.6955121e-05
2,365 Hypertree Decompositions and Tractable Queries 1999 PODS 8.5654557e-05
2,846 FactorJoin: A New Cardinality Estimation Framework for Join Queries 2023 SIGMOD 7.9453616e-05
3,153 Robust Join Processing with Diamond Hardened Joins 2024 VLDB 7.5883271e-05
3,592 Looking Ahead Makes Query Plans Robust: Making the Initial Case with In-Memory Star Schema Data Warehouse Workloads 2017 VLDB 7.1835842e-05
4,369 Predicate Transfer: Efficient Pre-Filtering on Multi-Join Queries 2024 CIDR 6.6315141e-05
4,391 Bitvector-aware Query Optimization for Decision Support Queries 2020 SIGMOD 6.6214093e-05
4,758 SQLite: Past, Present, and Future 2022 VLDB 6.4318211e-05
4,852 LpBound: Pessimistic Cardinality Estimation using ℓp-Norms of Degree Sequences 2025 SIGMOD 6.3806134e-05
4,950 Debunking the Myth of Join Ordering: Toward Robust SQL Analytics 2025 SIGMOD 6.3421691e-05
5,219 SafeBound: A Practical System for Generating Cardinality Bounds 2023 SIGMOD 6.222726e-05
5,891 Unified Query Optimization in the Fabric Data Warehouse 2024 SIGMOD 5.9570227e-05
5,902 Yannakakis+: Practical Acyclic Query Evaluation with Theoretical Guarantees 2025 SIGMOD 5.9536872e-05
6,467 Output-sensitive Conjunctive Query Evaluation 2024 PODS 5.7747248e-05
6,573 Output-Optimal Algorithms for Join-Aggregate Queries 2025 PODS 5.7455776e-05
6,721 Near-Optimal Distributed Band-Joins through Recursive Partitioning 2020 SIGMOD 5.6981399e-05
7,817 Parachute: Single-Pass Bi-Directional Information Passing 2025 VLDB 5.4477841e-05
7,932 Including Bloom Filters in Bottom-up Optimization 2025 SIGMOD 5.4236595e-05
8,073 Tight Bounds of Circuits for Sum-Product Queries 2024 PODS 5.3942942e-05
8,132 Diva: Dynamic Range Filter for Var-Length Keys and Queries 2025 VLDB 5.3931086e-05
8,269 Accelerate Distributed Joins with Predicate Transfer 2025 SIGMOD 5.3648571e-05
8,274 Scaling GPU-Accelerated Databases beyond GPU Memory Size 2025 VLDB 5.3642256e-05
9,410 Output-Sensitive Evaluation of Regular Path Queries 2025 PODS 5.1826718e-05
10,103 Still Asking: How Good Are Query Optimizers, Really? 2025 VLDB 5.0789354e-05
10,884 FlowLog: Efficient and Extensible Datalog via Incrementality 2026 VLDB 4.9793485e-05
Previous Page 1 / 1 Next

Semantically Similar Papers