DB2 Advisor: An optimizer smart enough to recommend its own indexes

DB2 Advisor: An optimizer smart enough to recommend its own indexes (2000)

Cached

Download Links

Other Repositories/Bibliography

DBLP

by Gary Valentin , Michael Zuliani , Daniel C. Zilio

Venue:	In ICDE
Citations:	73 - 4 self

BibTeX

@INPROCEEDINGS{Valentin00db2advisor:,
    author = {Gary Valentin and Michael Zuliani and Daniel C. Zilio},
    title = {DB2 Advisor: An optimizer smart enough to recommend its own indexes},
    booktitle = {In ICDE},
    year = {2000},
    pages = {101--110}
}

Years of Citing Articles

Bookmark

OpenURL

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. 1.

Citations

141	Index selection for OLAP - Gupta, Harinarayan, et al. - 1997
71	Physical database design for relational databases - Finkelstein, Schkolnick, et al. - 1988
18	Exact and approximate algorithms for the index selection problem in physical database design - Caprara, Fischetti, et al. - 1995
15	On the selection of an optimal set of indexes - Ip, Saxton, et al. - 1983
13	Optimal selection of secondary indexes - Barucci, Pinzani, et al. - 1990
9	Physical Database Design Decision Algorithms and Concurrent Reorganization for Parallel Database Systems - Zilio - 1998
8	Adaptive and automated index selection - Frank, Omiecinski, et al. - 1992
6	Narasayya: AutoAdmin “What-if” Index Analysis Utility - Chaudhuri - 1998
2	and Vivek Narasayya. Microsoft index tuning wizard for SQL Server 7.0 - Chaudhuri - 1998
2	Comments on an Optimal Set of Indices for a Relational Database - Falkowski - 1992