|
1. |
Autonomous Management of Soft Indexes
Liihring, M.; Sattler, K.-U.; Schmidt, K.; Schallehn, E.;
Data Engineering Workshop, 2007 IEEE 23rd International Conference on
17-20 April 2007
Page(s):450
-
458
Abstract:
In recent years the support for index tuning as pan of physical database design has gained focus in research and product development, which resulted in index and design advisors. Nevertheless, these tools provide a one-off solution for a continuous task and are not deeply integrated with the DBMS functionality by only applying the query optimizer for index recommendation and profit estimation and decoupling the decision about and execution of index configuration changes from the core system functionality. In this paper we propose an approach that continuously collects statistics for recommended indexes and based on this, repetitively solves the Index Selection Problem (lSP).A key novelty is the on-the-fly index generation during query processing implemented by new query plan operators In-dexBuildScan and SwitchPlan. Finally, we present the implementation and evaluation of the introduced concepts as part of the PostgreSQL system.
|
Cart
