The MemSQL Query Optimizer: A modern optimizer for real-time analytics in a distributed database
Summary: Presents MemSQL’s distribution-aware optimizer for sub-second, complex analytics on a scale-out engine. Jointly considers rewrites, join enumeration, and distributed costing, using rewrite-based bushy-join exploration to improve plans without sacrificing optimization speed. (summarized by gpt-5.6-luna on Jul 24 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Jack Chen (MemSQL)
- 2. Samir Jindel (MemSQL)
- 3. Robert Walzer (MemSQL)
- 4. Rajkumar Sen (MemSQL)
- 5. Nika Jimsheleishvilli (MemSQL)
- 6. Michael Andrews (MemSQL)
BibTeX Citation
@article{chen_vldb16,
title = {{The MemSQL Query Optimizer: A modern optimizer for real-time analytics in a distributed database}},
author = {Chen, Jack and Jindel, Samir and Walzer, Robert and Sen, Rajkumar and Jimsheleishvilli, Nika and Andrews, Michael},
journal = {PVLDB},
series = {{VLDB} '16},
volume = {9},
number = {13},
pages = {1401--1412},
doi = {10.14778/3007263.3007272},
url = {https://doi.org/10.14778/3007263.3007272},
year = {2016}
}Incoming Citations (Sorted by Pagerank)
Showing 21 of 21 citing papers.
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 10 of 10 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 1 | Access Path Selection in a Relational Database Management System | 1979 | SIGMOD | 0.0023943337 |
| 178 | The Vertica Analytic Database: C-Store 7 Years Later | 2012 | VLDB | 0.00026620521 |
| 321 | Measuring the Complexity of Join Enumeration in Query Optimization | 1990 | VLDB | 0.00021082176 |
| 480 | The Making of TPC-DS | 2006 | VLDB | 0.00017615432 |
| 708 | Optimization of Large Join Queries: Combining Heuristics and Combinatorial Techniques | 1989 | SIGMOD | 0.00014623779 |
| 1,277 | Orca: A Modular Query Optimizer Architecture for Big Data | 2014 | SIGMOD | 0.00011234276 |
| 2,089 | Query Optimization in Microsoft SQL Server PDW | 2012 | SIGMOD | 9.0635188e-05 |
| 3,777 | Parallelizing Query Optimization | 2008 | VLDB | 7.0240115e-05 |
| 4,052 | Of Snowstorms and Bushy Trees | 2014 | VLDB | 6.8257821e-05 |
| 6,138 | Parallelizing Extensible Query Optimizers | 2009 | SIGMOD | 5.8732713e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 7,202 | Optimizing Queries over Partitioned Tables in MPP Systems | 2014 | SIGMOD |
| 2 | 10,519 | Succinct Structure Representations for Efficient Query Optimization | 2026 | SIGMOD |
| 3 | 3,777 | Parallelizing Query Optimization | 2008 | VLDB |
| 4 | 6,138 | Parallelizing Extensible Query Optimizers | 2009 | SIGMOD |
| 5 | 7,712 | Query Centric Partitioning and Allocation for Partially Replicated Database Systems | 2017 | SIGMOD |
| 6 | 345 | R* Optimizer Validation and Performance Evaluation for Distributed Queries | 1986 | VLDB |
| 7 | 9,628 | Parallelizing Query Optimization on Shared-Nothing Architectures | 2016 | VLDB |
| 8 | 2,225 | Shared Workload Optimization | 2014 | VLDB |
| 9 | 4,732 | MQJoin: Efficient Shared Execution of Main-Memory Joins | 2016 | VLDB |
| 10 | 2,089 | Query Optimization in Microsoft SQL Server PDW | 2012 | SIGMOD |