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:

These tasks should always be performed immediately after you complete an ETL load on one of the underlying databases.


 Siebel Analytics Performance Tuning Guide 
 Published: 18 April 2003