DB2 Advisor: An Optimizer Smart Enough to Recommend Its Own Indexes G. Valentin, M. Zuliani, D. Zilio, G. Lohman, and A. Skelley   View Paper (PDF)   Return to Fast and Reliable Database Engines 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 knapack problem. This paper will discuss our implementation of index recommendation, the user interface, and provide measurements on the quality of the recommended indexes. Keywords: Relational Database, Optimizer, Index Selection, Knapsack Algorithm, Auto-Tuning, Self-Tuning, Database Design, Wizard DiSC'01 Copyright ©2002 ACM Inc.