In the Indexes view of the IBM® Table Designer,
you define the relational indexes for the IBM database table.
Indexes
Shows the relational indexes for the table.
Index Properties
Set the property values for the relational index
that is selected in Indexes list. An
unavailable property is a limitation of the database
that you are using.
Select a property to see its description in the box under
the properties list. If the description exceeds the size
of the box, hover the mouse pointer over the last line of
text in the box. After a brief pause, the full description
is shown in a ScreenTip.
Column Selection
In this section, you select the columns for the relational index.
Available Columns
Shows the columns that you can include in the relational
index that is selected in the Indexes list. To move
a column to the Selected Columns list, select
its name and then click the right arrow button.
Selected Columns
Shows the columns that define the relational index that
is selected in the Indexes list.
To remove a column from the list, select the column and
then click the left arrow button.