Index management

Many performance problems are the result of less-than-optimal index configurations. If you suspect an index problem:

Make sure the right indexes are in place. An index may be lost during maintenance (for example, a table is dropped and restored, but the index is not re-created). In particular, ensure that the primary key indexes are in place for best consolidation performance:

• PK_FINLOC_BASE
• PK_FINPER_BASE
• PK_FINYTD_BASE

Run your database index maintenance tool to clean up and optimize the indexes.

(Microsoft SQL Server Only) Use the DBCC DBReindex command once for each main fact table. For example:

DBCC DBReindex ('Ctrain.Ctrain.Finloc_Base', PK_Finloc_Base

(Oracle Only) Use the Analyze command, once for each main fact table. For example:

Analyze Table Ctrain.Finloc_Base Estimate Statistics Sample 10 Percent;