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.9769913e-05
Overall Rank
10,368 | 30.32%
DOI
-
PDF
Download (CC BY 4.0)

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.00064013679
15 How Good Are Query Optimizers, Really? 2016 VLDB 0.00061067652
208 EmptyHeaded: A Relational Engine for Graph Processing 2016 SIGMOD 0.00024899872
315 Worst-Case Optimal Join Algorithms: Techniques, Results, and Open Problems 2018 PODS 0.00021236408
889 SuRF: Practical Range Query Filtering with Fast Succinct Tries 2018 SIGMOD 0.00013243846
1,765 SQL Server Column Store Indexes 2011 SIGMOD 9.6934008e-05
2,366 Hypertree Decompositions and Tractable Queries 1999 PODS 8.5614655e-05
2,844 FactorJoin: A New Cardinality Estimation Framework for Join Queries 2023 SIGMOD 7.9446987e-05
3,154 Robust Join Processing with Diamond Hardened Joins 2024 VLDB 7.5849549e-05
3,593 Looking Ahead Makes Query Plans Robust: Making the Initial Case with In-Memory Star Schema Data Warehouse Workloads 2017 VLDB 7.1803217e-05
4,371 Predicate Transfer: Efficient Pre-Filtering on Multi-Join Queries 2024 CIDR 6.6284915e-05
4,394 Bitvector-aware Query Optimization for Decision Support Queries 2020 SIGMOD 6.6182964e-05
4,760 SQLite: Past, Present, and Future 2022 VLDB 6.4288554e-05
4,854 LpBound: Pessimistic Cardinality Estimation using ℓp-Norms of Degree Sequences 2025 SIGMOD 6.3775929e-05
4,945 Debunking the Myth of Join Ordering: Toward Robust SQL Analytics 2025 SIGMOD 6.3418058e-05
5,224 SafeBound: A Practical System for Generating Cardinality Bounds 2023 SIGMOD 6.2197808e-05
5,891 Unified Query Optimization in the Fabric Data Warehouse 2024 SIGMOD 5.9542027e-05
5,895 Yannakakis+: Practical Acyclic Query Evaluation with Theoretical Guarantees 2025 SIGMOD 5.9534254e-05
6,469 Output-sensitive Conjunctive Query Evaluation 2024 PODS 5.7719911e-05
6,576 Output-Optimal Algorithms for Join-Aggregate Queries 2025 PODS 5.7428578e-05
6,725 Near-Optimal Distributed Band-Joins through Recursive Partitioning 2020 SIGMOD 5.6954425e-05
7,810 Parachute: Single-Pass Bi-Directional Information Passing 2025 VLDB 5.4477354e-05
7,936 Including Bloom Filters in Bottom-up Optimization 2025 SIGMOD 5.4210921e-05
8,080 Tight Bounds of Circuits for Sum-Product Queries 2024 PODS 5.3917406e-05
8,138 Diva: Dynamic Range Filter for Var-Length Keys and Queries 2025 VLDB 5.3905556e-05
8,275 Accelerate Distributed Joins with Predicate Transfer 2025 SIGMOD 5.3623175e-05
8,280 Scaling GPU-Accelerated Databases beyond GPU Memory Size 2025 VLDB 5.3616863e-05
9,420 Output-Sensitive Evaluation of Regular Path Queries 2025 PODS 5.1802184e-05
10,107 Still Asking: How Good Are Query Optimizers, Really? 2025 VLDB 5.0765311e-05
10,893 FlowLog: Efficient and Extensible Datalog via Incrementality 2026 VLDB 4.9769913e-05
Previous Page 1 / 1 Next

Semantically Similar Papers