Enhancing SQL Query Performance via XAI: A Dual SHAP–LIME Framework for Accurate Response Time Prediction and Optimization in RDBMS
Optimization of queries in RDBMSs have been one of the most important roadblocks as the rule-based optimizer s fail to scale to the non-linear nature of the new analytical workloads. Although Machine Learning (ML) models have demonstrated good latency predictability, their poor interpret-ability creates a Trust Ga...