Index management

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

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

PK_FINLOC_BASE
PK_FINPER_BASE
PK_FINYTD_BASE

Add side indexes if necessary. Side indexes help performance if the "foundDataTime (SelectFirstNode portion)" time is large. For each hierarchical dimension, create a side index containing that dimension and all flat dimensions.

Remove the FinLoc_Lookup, FinPer_Lookup and FinYTD_Lookup indexes from corresponding "_Base" tables. These indexes degrade writeback performance.

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