Creating Models › Creating a Physical Model › Indexes › Create a Unique or Non-Unique Index

Create a Unique or Non-Unique Index

Use the Table Index Editor to create a new unique (alternate key, or AK) or non-unique (inverted entry, or IE) index for a table in the physical model.

To create a unique or non-unique index

1. Right-click the table in the Model Explorer for which you want to create an index and click Index Properties.

   The Table Index Editor opens.

2. Click New on the toolbar and select either New Unique Index or New Non-Unique Index and work with the following options:

   Physical Name

   Specifies the physical name of the index. Change the physical name of the index in this field.

   AK ID

   Displays key designation of the index.

   Is Unique

   Specifies if the index is unique or non-unique. Select the check box if it is a unique index.

   Physical Only

   Specifies whether the index should be suppressed from a logical model and appear in a physical model only.

   Generate

   Generates SQL during forward engineering. Clear the check box if you do not want to generate SQL.

   Generate As Constraint

   Generates the index as a constraint. Select the check box to enable this option. When this option is enabled, the Constraint Name field in this editor is populated with the index name.

   Note: Not all target servers support this option.

3. Click the Members tab and work with the following options:

   Index Members

   Lists the columns defined to the table and lets you specify the columns to place into the index. You can use the toolbar to specify sort order, move columns up or down in the list, invoke the Column Editor to manage column properties, or open the Reset Order dialog to reset column order.

   Also Include

   Specifies other non-key columns to include in the index. These columns are not part of the index but are stored along with the index columns in the index data area for fast retrieval. This optimizes retrieval speed because a read of this column is satisfied from the index data area, without accessing the row from the row data area. You can use the toolbar to specify sort order, move columns up or down in the list, or invoke the Table Column Editor to manage column properties.

4. Work with the other tabs to further define the index.
5. Click Close.

   The index is created and the Table Index Editor closes.

More information:

Table Index Editor