Table (Indices) H

Table (Indices) V

Use this page to Create Indices for Tables.

To access this page:

  1. Select Tables on the Navigation pane.
  2. Click the Indices icon for a table.
Field Description
Build Index Click to schedule the rebuild process for all indices in the Target Source table index. Only keys stored in the table are rebuilt.
INDEX ID Displays name of index.
UNIQUE INDEX If enabled, a unique index is built. The primary key can’t also be enabled. If Unique Index and Primary Key are both disabled, a non-unique index is built. Default value is Disabled.
PRIMARY KEY If enabled, index is built as a primary key for the table. Unique Index can’t also be enabled. If Unique Index and Primary Key are both disabled, a non-unique index is built. Default value is Disabled.
CLUSTERED INDEX If enabled, index is marked as clustered.  Default value is Disabled.
SOURCE DOWNLOAD If enabled, index settings were downloaded to the table. Otherwise, the index was supplied from group tables. This setting cannot be updated from within Collect.
Columns Click to open the Target Source Table Index Column page to add, edit and delete columns for table index.

Table (Indices) V

Table (Indices) H

Use this page to Create Indices for Tables.
Field Description
Build Index Click to schedule the rebuild process for all indices in the Target Source table index. Only keys stored in the table are rebuilt.
Index ID Displays name of the index.
Unique Index If enabled, a unique index is built. The primary key can’t also be enabled. If Unique Index and Primary Key are both disabled, a non-unique index is built. Default value is Disabled.
Primary Key If enabled, the index is built as a primary key for the table. Unique Index can’t also be enabled. If Unique Index and Primary Key are both disabled, a non-unique index is built. Default value is Disabled.
Source Download If enabled, index settings were downloaded to the table. Otherwise, the index was supplied from group tables. This setting cannot be updated from within Collect.
Index SQL Command Displays command that is run to create the index. Value is auto-generated.
Columns Click to open the Target Source Table Index Column page to add, edit and delete columns for table index.