Collect

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.