QO-Insight: Inspecting Steered Query Optimizers

Christoph Anneser, Mario Petruccelli, Nesime Tatbul, David Cohen, Zhenggang Xu, Prithviraj Pandian, Nikolay Laptev, Ryan Marcus, Alfons Kemper

Research output: Contribution to journalConference articlepeer-review

1 Scopus citations

Abstract

Steered query optimizers address the planning mistakes of traditional query optimizers by providing them with hints on a per-query basis, thereby guiding them in the right direction. This paper introduces QO-Insight, a visual tool designed for exploring query execution traces of such steered query optimizers. Although steered query optimizers are typically perceived as black boxes, QO-Insight empowers database administrators and experts to gain qualitative insights and enhance their performance through visual inspection and analysis.

Original languageEnglish
Pages (from-to)3922-3925
Number of pages4
JournalProceedings of the VLDB Endowment
Volume16
Issue number12
DOIs
StatePublished - 2023
Event49th International Conference on Very Large Data Bases, VLDB 2023 - Vancouver, Canada
Duration: 28 Aug 20231 Sep 2023

Fingerprint

Dive into the research topics of 'QO-Insight: Inspecting Steered Query Optimizers'. Together they form a unique fingerprint.

Cite this