Oracle® Business Intelligence Applications Upgrade Guide for Informatica PowerCenter Users Release 7.9.6.4 Part Number E35270-01 |
|
|
PDF · Mobi · ePub |
This appendix provides information about indexes that should be created to improve performance when using Oracle Financial Analytics. The indexes discussed in this appendix are applicable to Oracle BI Applications release 7.9.6.2.
Note:
After a successful data upgrade, you can drop the indexes referred to in this appendix, except for the ones that already existed in the DAC metadata.
This appendix includes the following topics:
Section C.1, "Indexes for SIL_PositionDimension_UPD7962 Mapping"
Section C.2, "Indexes for SIL_PositionDimensionHierarchy_UPD7962 Mapping"
Make sure the following indexes are created for the SIL_PositionDimension_UPD7962 mapping:
Primary key index on the ROW_WID column on table W_POSITION_D
Normal index on the INTEGRATION_ID and DATASOURCE_NUM_ID columns on table W_POSITION_D_7962
Make sure the following indexes are created for the SIL_PositionDimensionHierarchy_UPD7962 mapping:
Primary key index on ROW_WID column on table W_POSITION_D
Primary key index on ROW_WID column on table W_POSITION_DH
Primary key index on ROW_WID column on table W_POSITION_DH_7962
Unique index on INTEGRATION_ID, DATASOURCE_NUM_ID, and EFFECTIVE_FROM_DT columns on table W_POSITION_D
Unique index on BASE_POSTN_ID, DATASOURCE_NUM_ID, and EFFECTIVE_FROM_DT columns on table W_POSITION_DH_7962