DB2 advisor: an optimizer smart enough to recommend its own indexes

Authors:
  • MZM. Zuliani
    M. Zuliani
  • DZD.C. Zilio
    D.C. Zilio
  • GLG. Lohman
    G. Lohman
  • ASA. Skelley
    A. Skelley

Abstract
This paper introduces the concept of letting an RDBMS optimizer optimize its own environment. In our project, we have used the DB2 optimizer to tackle the index selection problem, a variation of the knapsack problem. This paper discusses our implementation of index recommendation, the user interface, and provide measurements on the quality of the recommended indexes.

This publication has 9 references indexed in Scilit: