Bookshelf Home | Contents | Index | Search | PDF |
Siebel Analytics Performance Tuning Guide > The Database Servers >
Periodic Tuning Tasks
Tuning a database for query performance is an ongoing, periodic activity. As the tables in the underlying databases change during load and other update operations, the indexes themselves change. The changes to tables can be sufficient to render some indexes useless and provide opportunities to add new indexes. These changes also necessitate reorganizing indexes and refreshing their statistics.
This section describes these tasks:
- Periodic index evaluation
- Refresh optimizer statistics
- Reorganize indexes
These tasks should always be performed immediately after you complete an ETL load on one of the underlying databases.
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Analytics Performance Tuning Guide Published: 18 April 2003 |