Indexes

The Indexes option screen displays when you select option 3 from the Object Selection menu. It lets you specify whether you want to create, alter, drop, or model an index. The following figure shows a sample screen.

Indexes Option Screen

OPTION

Specify the letter that represents the activity you want to pursue.

Specify Index Information: (* or pattern for list) Area

Creator

Specify your creator ID. You can also specify a generic name with * (asterisk), or a pattern. This displays the Index Selection window, from which you can select a specific object.

Index Name

Name of the index you want to create, alter, drop, or model. Required if you are modeling an index. You can also specify a generic name with * (asterisk), or a pattern. This displays the Index Selection window, from which you can select a specific object.

Specify CREATE Index Options: (* or pattern for list) Area

Table Creator

ID of the user who created the table on which the index is based. This field is required if you are creating an index. If this information is in your user profile (see Defaults-and-user-parameters-function for details), the field is prefilled. Required when you are creating an index.

You can also specify a generic name with * (asterisk), or a pattern. This displays the Index Selection window, from which you can select a specific object.

Table Name

Name of the table on which the index is based. If you have just finished creating the table, the field is prefilled. This field is required if you are creating an index. Not used if you are modeling an index.

You can also specify a generic name with * (asterisk), or a pattern. This displays the Index Selection window, from which you can select a specific object.