Oracle^® Business Intelligence Data Warehouse Administration Console Guide > Customizing, Designing, Executing and Monitoring ETL Processes >

Adding an Index to the Data Warehouse

Follow this procedure to add a new index to the data warehouse.

To add a new index to the data warehouse

1. Add the new index definition into the data warehouse database.
2. In the DAC toolbar, select the appropriate source system container from the drop-down list in the toolbar.
3. In the Menu bar, click Views > Design > Tables.
4. Query for the table for which you want to import index definitions.
5. Right-click and select Import from Database > Import Indices.
6. Choose to import indices for a selected table or for all the records retrieved in your query, and click OK.
7. In the Import Indices dialog box, select DataWarehouse from the Data Sources drop-down list.
8. Click Read Indices.
   1. In the list of indices displayed, select the Import check box for the indices you want to import.
   2. Click Import Indices.

      An informational message indicates whether the process was successful.