Export Citations
Save this search
Please login to be able to save your searches and receive alerts for new content matching your search criteria.
- research-articleMay 2024
Wii: Dynamic Budget Reallocation In Index Tuning
Proceedings of the ACM on Management of Data (PACMMOD), Volume 2, Issue 3Article No.: 182, Pages 1–26https://doi.org/10.1145/3654985Index tuning aims to find the optimal index configuration for an input workload. It is often a time-consuming and resource-intensive process, largely attributed to the huge amount of "what-if" calls made to the query optimizer during configuration ...
- research-articleMarch 2024
Wred: Workload Reduction for Scalable Index Tuning
Proceedings of the ACM on Management of Data (PACMMOD), Volume 2, Issue 1Article No.: 50, Pages 1–26https://doi.org/10.1145/3639305Modern database systems offer index-tuning advisors that automatically identify a set of indexes to improve workload performance. Advisors leverage the optimizer's what-if API to optimize a query for a hypothetical index configuration. Because what-if ...
- research-articleJune 2022
ISUM: Efficiently Compressing Large and Complex Workloads for Scalable Index Tuning
SIGMOD '22: Proceedings of the 2022 International Conference on Management of DataJune 2022, Pages 660–673https://doi.org/10.1145/3514221.3526152Today's database systems include index advisors that recommend an appropriate set of indexes for an input workload. Since index tuning on large and complex workloads can be resource-intensive and time-consuming, workload compression techniques have been ...
- research-articleJune 2022
Budget-aware Index Tuning with Reinforcement Learning
- Wentao Wu,
- Chi Wang,
- Tarique Siddiqui,
- Junxiong Wang,
- Vivek Narasayya,
- Surajit Chaudhuri,
- Philip A. Bernstein
SIGMOD '22: Proceedings of the 2022 International Conference on Management of DataJune 2022, Pages 1528–1541https://doi.org/10.1145/3514221.3526128Index tuning aims to find the optimal index configuration for an input workload. It is a resource-intensive task since it requires making multiple expensive "what-if" calls to the query optimizer to estimate the cost of a query given an index ...