EUVIMEDEUVIMED entdecken
Crossref

Hint-QPT: Hints for Robust Query Performance Tuning

Haibo Xiu, Yang Li, Qianyu Yang, Weihang Guo, Yuxi Liu, Pankaj K. Agarwal, Sudeepa Roy, Jun Yang

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.

AbstractBibliografische AngabenZitierenVerwandte Studien

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}
}
Kostenlos starten →