Physical Modeling › Oracle Physical Property Editors › Column Editor Dialog › Column Editor Dialog - Index Tab

Column Editor Dialog - Index Tab

Use the Index tab in the Column Editor to manage index membership for the selected column. The following describes the options available for this tab:

• Index Membership

  Lists all the indexes that are attached to the current table. Selected items in this list show the primary key, alternate key, foreign key, and inversion entry indexes of which the selected column is a member. Select the check box next to an index name to assign the selected column to that index. Clear the check box next to an index name to remove the column from the index.

• Show FK Indexes

  Displays foreign key indexes in the Index Membership list. Clear this option to hide foreign key indexes.