The run time of Data Warehouse jobs can be greatly affected by the values of certain database parameters. Check the logs for your jobs and experiment with parameter settings to see their effects on performance.

Here are some important database parameters for Oracle, including some example values for the "target" database.

These are examples only, not requirements.

For the "source" database, example parameter values include sga_max_size of 1 GB and open_cursors value of 300.

For SQL Server, be sure that the transaction log size is large enough, and that enough RAM is allocated to the "target" database server. For SQL Server target databases, the bulk-logged recovery model is recommended, to minimize log space and permit high-performance bulk copy operations.

Important: Data Warehouse, when first installed, contains no database indexes at all. You should manually create indexes where appropriate to speed up your most common queries.