Physical Modeling › Indexes › Indexes Dialog › Define Index Members

Define Index Members

Use the Members tab in the Indexes dialog to select columns within a table and assign them to an index. Key groups that you create in the logical model become indexes in the physical model. By default, the columns in each foreign key index include all of the columns that are migrated from the same table. If a table includes foreign key columns from two different parent tables, two foreign key indexes, one for each parent table, are created.

To define index members

1. Click Indexes, Table on the Model menu.

   The Indexes dialog opens.

2. Click the Members tab.

   The Members tab opens.

3. Select from the following options and click OK:
   • Available Columns

     Lets you view all the columns in the table that are not members of the selected index. Double-click a column in this list to move it to the Index Members list.

   • Index Members

     Lets you view all the columns in the table that are members of the selected index. Double-click a column in this list to remove it as an index member and move it back into the Available Columns list. Use the up and down arrow buttons to move a selected column up or down one position in this list.

   • DESC

     Specifies to sort the selected index in descending order. Clear the check box to sort the index in ascending order.

     Note: This option is available only for target servers that support descending indexes.

   Index members are defined and the Indexes dialog closes.