DocumentCode
1960715
Title
DB2 advisor: an optimizer smart enough to recommend its own indexes
Author
Valentin, Gary ; Zuliani, Michael ; Zilio, Daniel C. ; Lohman, Guy ; Skelley, Alan
Author_Institution
IBM Canada Ltd., Toronto, Ont., Canada
fYear
2000
fDate
2000
Firstpage
101
Lastpage
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
database indexing; knapsack problems; query processing; relational databases; DB2 advisor; index quality measurement; index recommendation; index selection problem; knapsack problem; relational DBMS optimizer; user interface; Combinatorial mathematics; Constraint optimization; Cost function; Design optimization; Electrical capacitance tomography; Engines; Relational databases; Statistics; User interfaces;
fLanguage
English
Publisher
ieee
Conference_Titel
Data Engineering, 2000. Proceedings. 16th International Conference on
Conference_Location
San Diego, CA
ISSN
1063-6382
Print_ISBN
0-7695-0506-6
Type
conf
DOI
10.1109/ICDE.2000.839397
Filename
839397
Link To Document