Ai meets ai: Leveraging query executions to improve index recommendations
… query optimizer’s estimates. We study the problem of leveraging query execution statistics
to improve index recommendation quality with minimal changes to state-of-the-art index tuners…
to improve index recommendation quality with minimal changes to state-of-the-art index tuners…
Online Index Recommendation for Slow Queries
G Peng, P Cai, K Ye, K Li, J Cai, Y Shen… - 2024 IEEE 40th …, 2024 - ieeexplore.ieee.org
… As a result, index recommendation methods relying on cost … can still leverage the learned
position information of indexed … index can improve the query execution. If a candidate …
position information of indexed … index can improve the query execution. If a candidate …
A Data-Driven Index Recommendation System for Slow Queries
G Peng, P Cai, K Ye, K Li, J Cai, Y Shen… - Proceedings of the 32nd …, 2023 - dl.acm.org
… One of the key tasks in DAS is to find missing indexes to improve the slow query execution.
In Meituan, a vast array of business lines deploy tens of thousands of MySQL database …
In Meituan, a vast array of business lines deploy tens of thousands of MySQL database …
ML-Powered Index Tuning: An Overview of Recent Progress and Open Challenges
T Siddiqui, W Wu - ACM SIGMOD Record, 2024 - dl.acm.org
… by recommending indexes that accelerate query execution. … rate of queries for just-in-time
recommendation of indexes, … Our idea is to leverage statistics such as table size, selectivity…
recommendation of indexes, … Our idea is to leverage statistics such as table size, selectivity…
An adaptive query execution system for data integration
ZG Ives, D Florescu, M Friedman, A Levy… - ACM SIGMOD …, 1999 - dl.acm.org
… bibliographic references, movie reviews and product in… since they require an initial sorting
or indexing step in this context. Even … Wherever possible, w,e leverage pre-existing standards, …
or indexing step in this context. Even … Wherever possible, w,e leverage pre-existing standards, …
Learned index benefits: Machine learning based index performance estimation
J Shi, G Cong, XL Li - Proceedings of the VLDB Endowment, 2022 - dl.acm.org
… to estimate execution cost for each query under an index … to leverage attention mechanism
to learn the index interactions … index tuner with LIB can enhance the index recommendation. • …
to learn the index interactions … index tuner with LIB can enhance the index recommendation. • …
Rboira: Integrating rules and reinforcement learning to improve index recommendation
W Yu, J You, X Niu, J He, Y Zhang - EAI Endorsed Transactions …, 2023 - publications.eai.eu
… configuration by leveraging expert experience. OBJECTIVES… improves execution efficiency
and reduces the execution cost. (2… indexes on corresponding columns can improve the query …
and reduces the execution cost. (2… indexes on corresponding columns can improve the query …
Wred: Workload Reduction for Scalable Index Tuning
… leverage the optimizer’s what-if API to optimize a query for a … queries for execution, but only
for improving the index tuning … the indexes recommended by Dexter as hypothetical indexes …
for improving the index tuning … the indexes recommended by Dexter as hypothetical indexes …
Leveraging recommendations using a multiplex graph database
… in improving recommendation accuracy and diversity by … be combined to create
recommendation queries for our framework. … Designed for efficiency, these databases use …
recommendation queries for our framework. … Designed for efficiency, these databases use …
Leon: A new framework for ml-aided query optimization
… framework for leveraging ML to aid the query optimizerÐLEON. … will guide the query optimizer
to find the best execution plan. … recommendations. In Proceedings of the 2019 International …
to find the best execution plan. … recommendations. In Proceedings of the 2019 International …