Table of Contents

Search

  1. Preface
  2. Using the Designer
  3. Working with Sources
  4. Working with Flat Files
  5. Working with Targets
  6. Mappings
  7. Mapplets
  8. Mapping Parameters and Variables
  9. Working with User-Defined Functions
  10. Using the Debugger
  11. Viewing Data Lineage
  12. Comparing Objects
  13. Managing Business Components
  14. Creating Cubes and Dimensions
  15. Using the Mapping Wizards
  16. Datatype Reference
  17. Configure the Web Browser

Defining Indexes

Defining Indexes

Since indexes speed queries against tables, adding indexes to the target database is an important part of target table design. You can add index information to relational target definitions. Queries to the data warehouse determine which columns you should index. If you define indexes, select the option to create indexes when you create target tables.
To create indexes for a target table:
  1. In the Target Designer, double-click the title bar of a relational target definition.
  2. Select the Indexes tab.
  3. To add an index, click the Add button in the Indexes section.
  4. Enter a name for the index and press Enter.
  5. To add a column to the index, click the Add button in the Columns section. Select a column name and click OK.
  6. Repeat steps 3 to 5 for each column you want to assign.
  7. Click OK.
Important:
When you generate and execute the DDL to create the target table, choose to create an index.


Updated July 02, 2020