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
589
Venue
CIDR
Year
2026
Pagerank
5.093636e-05
Overall Rank
10,135 | 30.47%
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.0006312782
18 How Good Are Query Optimizers, Really? 2016 VLDB 0.00059284255
211 EmptyHeaded: A Relational Engine for Graph Processing 2016 SIGMOD 0.00024797217
321 Worst-Case Optimal Join Algorithms: Techniques, Results, and Open Problems 2018 PODS 0.00021283186
880 SuRF: Practical Range Query Filtering with Fast Succinct Tries 2018 SIGMOD 0.00013432693
1,747 SQL Server Column Store Indexes 2011 SIGMOD 9.8494706e-05
2,330 Hypertree Decompositions and Tractable Queries 1999 PODS 8.7447066e-05
2,991 FactorJoin: A New Cardinality Estimation Framework for Join Queries 2023 SIGMOD 7.8880723e-05
3,571 Looking Ahead Makes Query Plans Robust: Making the Initial Case with In-Memory Star Schema Data Warehouse Workloads 2017 VLDB 7.2991953e-05
3,622 Robust Join Processing with Diamond Hardened Joins 2024 VLDB 7.2465862e-05
4,553 Predicate Transfer: Efficient Pre-Filtering on Multi-Join Queries 2024 CIDR 6.6346951e-05
4,849 Bitvector-aware Query Optimization for Decision Support Queries 2020 SIGMOD 6.4803828e-05
5,284 SQLite: Past, Present, and Future 2022 VLDB 6.2827906e-05
5,529 Debunking the Myth of Join Ordering: Toward Robust SQL Analytics 2025 SIGMOD 6.18591e-05
5,576 SafeBound: A Practical System for Generating Cardinality Bounds 2023 SIGMOD 6.1663946e-05
5,639 LpBound: Pessimistic Cardinality Estimation using ℓp-Norms of Degree Sequences 2025 SIGMOD 6.1385102e-05
6,434 Yannakakis+: Practical Acyclic Query Evaluation with Theoretical Guarantees 2025 SIGMOD 5.8799421e-05
6,444 Output-Optimal Algorithms for Join-Aggregate Queries 2025 PODS 5.8774519e-05
6,596 Near-Optimal Distributed Band-Joins through Recursive Partitioning 2020 SIGMOD 5.828647e-05
6,678 Output-sensitive Conjunctive Query Evaluation 2024 PODS 5.8053953e-05
7,055 Unified Query Optimization in the Fabric Data Warehouse 2024 SIGMOD 5.7170734e-05
7,904 Tight Bounds of Circuits for Sum-Product Queries 2024 PODS 5.5181056e-05
8,074 Parachute: Single-Pass Bi-Directional Information Passing 2025 VLDB 5.4929961e-05
8,308 Diva: Dynamic Range Filter for Var-Length Keys and Queries 2025 VLDB 5.4562543e-05
8,721 Accelerate Distributed Joins with Predicate Transfer 2025 SIGMOD 5.3772617e-05
9,235 Output-Sensitive Evaluation of Regular Path Queries 2025 PODS 5.3016261e-05
9,279 Including Bloom Filters in Bottom-up Optimization 2025 SIGMOD 5.2934632e-05
9,920 Still Asking: How Good Are Query Optimizers, Really? 2025 VLDB 5.1955087e-05
10,582 FlowLog: Efficient and Extensible Datalog via Incrementality 2026 VLDB 5.093636e-05
10,985 Scaling GPU-Accelerated Databases beyond GPU Memory Size 2025 VLDB 5.093636e-05
Previous Page 1 / 1 Next

Semantically Similar Papers