Hint-QPT: Hints for Robust Query Performance Tuning
Proceedings of the VLDB Endowment · 2025-08 · 18 (12) · 5327-5330
DOI: 10.14778/3750601.3750663 ↗Kurz gefasst
Fachartikel in der Zeitschrift Proceedings of the VLDB Endowment, online erschienen am 16.09.2025. Verfasst von Haibo Xiu und 7 weiteren Autor:innen. Die Arbeit wurde bisher 2-mal zitiert (Crossref) und nennt 13 Literaturangaben.
Abstract (Originalsprache)
Query optimizers rely heavily on selectivity estimates to choose efficient execution plans, but inaccuracies in these estimates often result in poor query performance. We introduce Hint-QPT ( Hint s for Robust Q uery P erformance T uning), an interactive tool designed to help users diagnose and improve query performance. Hint-QPT proactively recommends robust plans that are resilient to uncertainty in selectivity estimates, identifies sensitive subqueries for which selectivity estimation errors greatly affect plan quality, and provides intuitive interfaces for targeted selectivity adjustments. Users can either choose the recommended robust plans for execution, or acquire additional statistics on the identified sensitive subqueries to tune query performance. Moreover, Hint-QPT visualizes the alternative execution plans and their costs under uncertainty, helping users to better understand their robustness.
Zitieren
APA
Xiu, H., Li, Y., Yang, Q., Guo, W., Liu, Y., Agarwal, P. K., Roy, S., & Yang, J. (2025). Hint-QPT: Hints for Robust Query Performance Tuning. Proceedings of the VLDB Endowment, 18(12), 5327-5330. https://doi.org/10.14778/3750601.3750663
Vancouver
Xiu H, Li Y, Yang Q, Guo W, Liu Y, Agarwal PK, et al. Hint-QPT: Hints for Robust Query Performance Tuning. Proceedings of the VLDB Endowment. 2025;18(12):5327-5330. doi:10.14778/3750601.3750663
BibTeX
@article{Xiu2025,
author = {Xiu, Haibo and Li, Yang and Yang, Qianyu and Guo, Weihang and Liu, Yuxi and Agarwal, Pankaj K. and Roy, Sudeepa and Yang, Jun},
title = {Hint-QPT: Hints for Robust Query Performance Tuning},
journal = {Proceedings of the VLDB Endowment},
year = {2025},
volume = {18},
number = {12},
pages = {5327--5330},
doi = {10.14778/3750601.3750663}
}
EUVIMED