Table (Indices) H

To access this page:

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

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.