Semi-Automatic Index Tuning: Keeping DBAs in the Loop
To obtain a high level of system performance, a DataBase Administrator (DBA) must choose a set of indices that is appropriate for the workload. The system can aid in this challenging task by providing recommendations for the index configuration. The authors propose a new index recommendation technique, termed semi-automatic tuning, that keeps the DBA "In the loop" by generating recommendations that use feedback about the DBA's preferences. The technique also works online, which avoids the limitations of commercial tools that require the workload to be known in advance.