Add a Column to an Index

To add a column to an index

  1. In the physical model, right-click the table that contains the column, and select Columns.
  2. Select the column you want to modify in the Column list.
  3. Select the Index tab.
  4. Select the check box next to an index name in the Index Membership list to include the column as a member of that index and click OK.

More information:

Define Column Index Membership