Deploying a Steered Query Optimizer in Production at Microsoft
Summary: Steers a query optimizer toward workload-specific plans by pushing exploration offline in QO-Advisor, deployed in production at Microsoft. Externalizes planning to an offline pipeline, budgets steering actions, avoids regressions, and enables default use on SCOPE workloads. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Wangda Zhang (Microsoft)
- 2. Matteo Interlandi (Microsoft)
- 3. Paul Mineiro (Microsoft)
- 4. Shi Qiao (Microsoft)
- 5. Nasim Ghazanfari (Microsoft)
- 6. Karlen Lie (Microsoft)
- 7. Marc Friedman (Microsoft)
- 8. Rafah Hosn (Microsoft)
- 9. Hiren Patel (Microsoft)
- 10. Alekh Jindal (Microsoft)
BibTeX Citation
@inproceedings{zhang_sigmod22,
title = {{Deploying a Steered Query Optimizer in Production at Microsoft}},
author = {Zhang, Wangda and Interlandi, Matteo and Mineiro, Paul and Qiao, Shi and Ghazanfari, Nasim and Lie, Karlen and Friedman, Marc and Hosn, Rafah and Patel, Hiren and Jindal, Alekh},
series = {{SIGMOD} '22},
booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
publisher = {Association for Computing Machinery},
doi = {10.1145/3514221.3526052},
url = {https://dl.acm.org/doi/10.1145/3514221.3526052},
year = {2022}
}
Incoming Citations (Sorted by Pagerank)
Showing 14 of 14 citing papers.
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 22 of 22 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 4,929 | AutoSteer: Learned Query Optimization for Any SQL Database | 2023 | VLDB |
| 2 | 3,988 | Adaptive Query Processing in the Looking Glass | 2005 | CIDR |
| 3 | 2,944 | Query Optimizers: Time to Rethink the Contract? | 2009 | SIGMOD |
| 4 | 2,822 | Cost Models for Big Data Query Processing: Learning, Retrofitting, and Our Findings | 2020 | SIGMOD |
| 5 | 4,742 | Continuous Cloud-Scale Query Optimization and Processing | 2013 | VLDB |
| 6 | 8,448 | Towards Query Optimizer as a Service (QOaaS) in a Unified LakeHouse Ecosystem: Can One QO Rule Them All? | 2025 | CIDR |
| 7 | 5,281 | Leveraging Re-costing for Online Optimization of Parameterized Queries with Guarantees | 2017 | SIGMOD |
| 8 | 2,078 | Query Optimization in Microsoft SQL Server PDW | 2012 | SIGMOD |
| 9 | 9,846 | QO-Insight: Inspecting Steered Query Optimizers | 2023 | VLDB |
| 10 | 5,059 | Steering Query Optimizers: A Practical Take on Big Data Workloads | 2021 | SIGMOD |