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

G. Valentin, M. Zuliani, D.C. Zilio, G. Lohman, A. Skelley
Proceedings of 16th International Conference on Data Engineering (Cat. No.00CB37073)  
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.
doi:10.1109/icde.2000.839397 dblp:conf/icde/ValentinZZLS00 fatcat:sxb56wqrbvhhpaw4hcudiz7a4u