Collect

Create Indices for Tables

Indices built during the Create Package process and are registered to a Target Source to improve performance. For the download process to perform better for large tables, drop and build the indices and/or the primary key.

Collect has the ability to build indices and primary keys for the target tables. Indices and primary keys are built with general SQL statements without considering space allocation or clustering. To use these features, create a customized rule containing the required SQL view and run it after a data download. For large tables, it is recommended to drop the index before downloading the data and to recreate the index after the data has been reloaded.

NOTE: Collect builds SAP Primary Keys during the Build Package process. Primary keys for source systems are automatically created if Download Indices Keys is enabled for the source. To build keys and indices for non-SAP sources, verify the Download Keys Indexes check box on theTarget Sourcepage's Vertical View is enabled.

To build indices or primary keys for SAP:

  1. Click Targets in Navigation pane.
  2. Click Sources for Target.
  3. Click Tables for Source. 
  4. Click Indices for Table.

  5. Click Add.

    View the field descriptions for the Table (Indices) page

  6. Enter a name in INDEX ID field.

  7. Click UNIQUE INDEX check box to build a unique index.

    OR

    Click PRIMARY KEY check box to build the index as a primary key for the tables.

  8. Click CLUSTERED INDEX check box to mark the index as clustered.

    NOTE: CLUSTERED INDEX can be used with PRIMARY KEY to create a clustered or non-clustered primary key.

  9. Click Save.
  10. Click Columns for Indices.

  11. Click Add.

    View the field descriptions for the Target Source Table Index Columns page

  12. Select a value from COLUMN list box to indicate the table column impacted by the index.

  13. Update COLUMN ORDER field if the default value is not applicable.

    NOTE:TheCOLUMN ORDER field controls the sort order of the column.

  14. Click Save.
  15. Click Back button on Browser to return to Table (Indices) page.

  16. Click Build Indices icon to schedule the rebuild process for all index in Target Source Table index; a confirmation message displays.

    NOTE: Only indices and keys registered to the table are rebuilt.

  17. Click Ok.

NOTE: Indices are built in the background and may take several minutes.