Creating Models › Creating a Physical Model › Indexes › Table Index Editor

Table Index Editor

A primary key (PK) and a foreign key (IF) index is automatically created for each table in your model, based on the primary key and foreign key columns. If you designate columns as an alternate key group (AK) or inversion entry group (IE), the equivalent unique (AK) and non-unique (IE) indexes are also generated.

Use the Table Index Editor to create alternate key (unique) and inversion entry (non-unique) indexes for tables in your model. After you create an index, you can use the Table Index Editor to modify its properties, such as the index name, column members, physical properties, and user-defined properties.

Note: You can use the Table Index Editor to create AK and IE indexes, but not a PK index or an IF index.

Use the following options and tabs in the Table Index Editor to view and update the properties for indexes:

Table

Displays the table to which the selected table index belongs.

Previous

Positions the editor on the previous table index in the Navigation Grid.

Next

Positions the editor on the next table index in the Navigation Grid.

Sort

Sorts the table indexes by alphabetic, reverse alphabetic, or index order. You select the method you want using the drop-down menu that opens after you click the Sort button.

New

Creates a new table index that becomes the current object in the editor.

Delete

Deletes the selected table index.

Help

Accesses online help for the editor.

Lets you enter text to filter a large list of table index objects so you can quickly locate the one that you want.

Show FK Indexes

Specifies to display FK (foreign key) indexes in the Navigation Grid.

Physical Name

Displays the physical name of the table index.

Type

Displays the table index type.

Is Unique

Specifies to allow only unique values in the table index. Clear this check box to allow non-unique values.

Note: This option is unavailable when a primary or foreign key index is selected.

Physical Only

Specifies whether to have the index appear in the physical model only. If you want the index to appear in the logical model as a key group, clear the check box.

Note: This option is unavailable when a primary or foreign key index is selected.

Generate

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

General Tab

Lets you specify physical properties for the table index.

Members Tab

Lets you specify the columns to place into the index. You can also include non-key columns 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.

Partitions Tab

Lets you define table index partition columns.

Where Used Tab

Lets you view where the table index is used in the model.

Comment Tab

Lets you enter any comments that you want to associate with the table index.

UDP Tab

Lets you work with user-defined properties for the table index.

Notes Tab

Lets you view or enter notes that you want to associate with the table index.