Collect
Table (Indices) H
Use this page to Create Indices for Tables.
To access this page:
- Select Tables on the Navigation pane.
- 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 |
|
Columns |
Click to open the Target Source Table Index Column page to add, edit and delete columns for table index. |
Table (Indices) V
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. |