PulseExploreJournal ClubDebatesTrendingResearchersJournals
Instagram
HomeExploreJournal ClubTrending
Synapse
⌘+K
Synapse
November 7, 2002294 citations

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

View Full Paper
GVGary ValentinMZMichael J. ZulianiDZDaniel C. Zilio

Key Points

Key points are not available for this paper at this time.

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.

Ask AI
Helpful
Bookmark
Share
View Full Paper

Cite This Study

Valentin et al. (2002) studied this question.

synapsesocial.com/papers/6a230a9a6873956e4bd26fb8https://doi.org/10.1109/icde.2000.839397
Ask AI
Helpful
Bookmark
Share
View Full Paper

Also Consider

Synapse has enriched 5 closely related papers on similar clinical questions. Consider them for comparative context:

  1. 1On the Selection of an Optimal Set of Indexes1983 · 56 citations
  2. 2Index selection for OLAP2002 · 425 citations
  3. 3Index Selection in Relational Databases1987 · 40 citations
  4. 4Integer programming1972 · 3,389 citations
  5. 5On the selection of secondary indices in relational databases1993 · 33 citations