DB2 Advisor: An Optimizer Smart Enough to Recommend Its Own Indexes

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.

• Type: Conference
• Year: 2000
• Where: ICDE
• Authors: Gary Valentin, Michael Zuliani, Daniel C. Zilio, Guy M. Lohman, Alan Skelley
• Keywords: Database, DB2 Optimizer, ICDE 2000, Index Selection Problem, RDBMS Optimizer