Modifying Indexes (Sets and Subsets)

Note: This task applies only to an Enterprise Database Server database that is mapped to SQL.

Perform the following steps to modify indexes (set and subsets):

  1. From the tree view, expand the server containing the database you want to modify.

  2. Expand the database you want to modify, and expand the Tables node representing each data set in the database.

  3. Expand the Indexes node to display the indices associated with the table.

  4. Select the index you want to modify.

    The following schema properties associated with the index appear in the properties view.

  5. Double-click the value for the Alias Index Name property, and type the name used for the SQL table represented by the set or subset. The alias name can be up to 30 characters long.

  6. Select the Ignore check box to make the index inaccessible to SQL queries. Otherwise, leave the check box cleared.