Collect

Table Index List in Source and Target

Use this page to view the Table Index List in Source and Target report.

To access this page:

  1. Select Collect > Reports in the Navigation pane.
  2. Click List Index List in Source and Target on the Reports page.

Field

Description

TARGET

Displays the database target where tables are refreshed with source data.

SOURCE

Displays the database where the data is refreshed from and stored in the target.

TABLE

Displays the table name in the source database and target database.

INDEX ID

Displays the name of the index in the table.

UNIQUE INDEX

If checked, a unique index is built. The primary key cannot be enabled at the same time. If the unique index and the primary key are both disabled, a non-unique index is built.

INDEX SQL COMMAND

Displays the command that is run to create the index.