Designer Guide

10.4.1
- 10.5.6
- 10.5
- 10.4.0

Back Next

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:

In the Target Designer, double-click the title bar of a relational target definition.

Select the Indexes tab.

To add an index, click the Add button in the Indexes section.

Enter a name for the index and press Enter.

To add a column to the index, click the Add button in the Columns section. Select a column name and click OK.

Repeat steps 3 to 5 for each column you want to assign.

Click OK.

Important:
When you generate and execute the DDL to create the target table, choose to create an index.

Maintaining Relational Target Definitions

Download Guide

Watch