DB2 advisor: an optimizer smart enough to recommend its own indexes
Authors:
- M. ZulianiMZM. Zuliani
- D.C. ZilioDZD.C. Zilio
- G. LohmanGLG. Lohman
- A. SkelleyASA. Skelley
- 7 November 2002
- conference paper
- Published by Institute of Electrical and Electronics Engineers (IEEE)
- No. 10636382,p. 101-110
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.Keywords
This publication has 9 references indexed in Scilit:
- Index selection for OLAP2002
- Microsoft index turning wizard for SQL Server 7.01998
- AutoAdmin “what-if” index analysis utility1998
- Exact and approximate algorithms for the index selection problem in physical database designIEEE Transactions on Knowledge and Data Engineering, 1995
- On the selection of secondary indices in relational databasesData & Knowledge Engineering, 1993
- Comments on an optimal set of indices for a relational databaseIEEE Transactions on Software Engineering, 1992
- Optimal selection of secondary indexesIEEE Transactions on Software Engineering, 1990
- Physical database design for relational databasesACM Transactions on Database Systems, 1988
- On the Selection of an Optimal Set of IndexesIEEE Transactions on Software Engineering, 1983