loading...
 This Article 
   
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
16th International Conference on Data Engineering (ICDE'00)
DB2 Advisor: An Optimizer Smart Enough to Recommend its own Indexes
San Diego, California
February 28-March 03
ISBN: 0-7695-0506-6
Gary Valentin, IBM Toronto Lab
Michael Zuliani, IBM Toronto Lab
Daniel C. Zilio, IBM Toronto Lab
Guy Lohman, IBM Almaden Research Center
Alan Skelley, University of Toronto
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.
Index Terms:
Relational Database, Optimizer, Index Selection, Knapsack Algorithm, Auto-Tuning, Self-Tuning, Database Design, Wizard
Citation:
Gary Valentin, Michael Zuliani, Daniel C. Zilio, Guy Lohman, Alan Skelley, "DB2 Advisor: An Optimizer Smart Enough to Recommend its own Indexes," icde, pp.101, 16th International Conference on Data Engineering (ICDE'00), 2000
Usage of this product signifies your acceptance of the Terms of Use.