Managing Table Indexes (2.14)
This page explains how to add custom indexes to tables in InterSystems Data Studio™ and explains how the system automatically builds indexes as needed.
Adding an Index to a Staging Table
Within the definition of a recipe, you can add custom indexes to the generated staging table. To do so:
-
Click the Recipes icon in the application menu.
-
If the recipe is in a group, expand that group.
-
Click the recipe name.
-
At the bottom of the page, see the list in Indices and Staging Table Details.
This section shows one row for each data source used in the recipe.
-
Click the row for a given data source. The page then lists the generated staging tables associated with this data source.
-
Click a table name in this list. The right side of the page then provides information about the indexes on the table, along with details about the fields in this table.
-
Click New Index.
-
For Index Name , type a unique index name.
-
For Index Fields, select the field(s) to index.
-
Click Submit.
-
Because there is now a new index, the Build Indices button is enabled. You can click that to immediately start building this index for any existing data in this staging table.
However, even if you do not click Build Indices, the system automatically schedules a background task that will build this index for any existing data in this staging table. The system also automatically indexes new data.
Adding an Index to a Snapshot
Within the definition of a snapshot, you can add custom indexes to the generated snapshot table. To do so:
-
Click the Snapshot icon in the application menu.
-
Click the snapshot you want to edit.
-
Click New Index.
-
For Index Name, type a unique index name.
-
For Index Fields , select the field(s) to index.
When you add an index, the system automatically detects this change and schedules a background task that will build this index for any existing data in this table. The system also automatically indexes new data.
Index Build Pending Message
Sometimes the process of building an index can be time-consuming and it is necessary to wait before performing recipe runs or snapshots that use the table being indexed. In such a case, the system displays a message indicating that it is in the process of building a required index. The system prevents you from prematurely using the data.