DB2 advisor: an optimizer smart enough to recommend its own indexes
Gary Valentin, Michael J. Zuliani, Daniel C. Zilio, Guy M. Lohman, Alan Ramsay Skelley · 2002
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.