Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Initializing and Populating the Siebel Customer-Centric Enterprise Warehouse >

Optimizing Database Performance

After setting up your database connections, but before loading any data, you may want to optimize your repository's database performance. To perform optimization, request your Database Administrator to run the appropriate, update-statistics operation for your RDBMS on all tables and indexes.

The optimization procedure updates information about the distribution of key values, and improves the performance of operations (for example, starting the workflow or opening mappings). It is also recommended that you run an update, statistics operation on both your source and target databases.

When the repository has been restored, and you are satisfied with your setup, you are then ready to run the Siebel Customer-Centric Enterprise Warehouse initialization workflows. For more information about initializing workflows, see About Working with Workflows.