Index owner
Index name
Table owner
Table name
Available columns
>>, >, <, <<
Selected columns
Unique
Percentage of free space to be left on index pages
Ascending and Descending
Up
Down
OK
Cancel
Show SQL
Index owner
Index name
Table owner
Table name
Available columns
>>, >, <, <<
Selected columns
Unique
Percentage of free space to be left on index pages
Ascending and Descending
Up
Down
OK
Cancel
Show SQL
Index owner
Use this box to specify the owner of the index that you are creating. The initial value in this box is the user ID under which you connected to the database. To specify an owner with a name that's different than this ID, use one of these methods:
Index name
Type a name for the index that you are creating. This name:
Attention: This name must be unique within the indexes created by the same owner. No other index owned by the same user id can have the same name.
Table owner
Use this box to specify the owner of the table on which you are creating an index. The initial value in this box is the user ID under which you connected to the database. To specify an owner with a name that's different than this ID, use one of these methods:
Table name
Click on the down arrow to display a list of existing tables and select the table on which the index is created. The table must be a base table (not a view) described in the catalog. It must not be a catalog table. The table name:
Available columns
This list box lists all of the columns defined for the table specified in the Table name field. Use this box to select the column or columns that you want to define as part of the index key. You can select one or more columns at the same time.
You can specify up to 16 columns. At least one column must be specified to define an index.
The sum of length attributes cannot be longer than 255.
>>, >, <, <<
Use these push buttons to change the list of columns displayed in the Available columns, Selected columns, and Include columns list boxes. You can use:
Selected columns
Use this box to specify the column or columns that you want to define as part of the index key.
To add a column name to this box, select it from the Available columns list box and select the > push button.
You can specify up to 16 columns. At least one column must be specified to define an index.
The sum of the length attributes of the specified columns must not be greater than 255 bytes.
Unique
Select this check box to indicate that a table will not contain two or more rows with the same value of the index key. The constraint is enforced when rows of the table are updated or new rows are inserted. The constraint is also checked during the execution of the CREATE INDEX statement. If the table already contains rows with duplicate key values, the index is not created.
When the Unique check box is selected, null values are treated as any other values. For example, if the key is a single column that can contain null values, that column can contain no more than one null value.
Percentage of free space to be left on index pages
Use this field to specify the percentage of each index page to leave as free space when building the index.
The first entry in a page is added without restriction. When additional entries are placed in an index page, the value specified in this field determines the percentage of free space left on each page.
Select a percent from 0 to 99. The default value is 10 percent. If you select a value greater than 10, only 10 percent free space will be left in non-leaf pages.
Ascending and Descending
Use these radio buttons to specify the sort order of the columns that you selected in the Selected columns list box.
