The Index wizard allows you to specify index properties for OpenEdge databases. You use it to specify the properties of a new index or to change the properties of an existing index.

Start the Index wizard by clicking Add Index or Edit Index . Both are available from context menus in the DB Structure view and from the OpenEdge Index tab of the OpenEdge DB Details view.

The Index wizard allows you to specify the following properties:

Name An index name that is unique within the selected table. Index names must follow certain conventions.
Scope Defines whether the current index is Local or Global.
Note: Local indexes are created only for partitioned tables. A local index is a partition-aligned index that has a partition key column as the leading prefix of its constraint columns. By default, a global index is created for tables that are not partitioned; hence, the Local and Global options are disabled for tables that are not partitioned.
Area A storage area from a list of storage areas defined for the database.
Note: When you select Local, the Area field is disabled, since partition areas are defined while defining partition rules.
Description A description of the index for documentation purposes.
Primary When selected, designates the index as the most frequently used index. OpenEdge allows you to set one index as primary and uses it by default when retrieving or ordering records.
Active When selected, enables the index to be used to retrieve or order records. An active index updates itself every time a new record is created, deleted, or modified.
Unique When selected, indicates that every index key must be unique (for example, a social security number).
Word Index When selected, indicates that all words in the field are index entries. An index that contains all the words from a text field (or array of text fields) allows you to search for records containing specific words or phrases.
Note: A word index cannot be a primary index. Also, a local index cannot be a word index; so, when you select Local, the Word index option is disabled.
Fields (Add Index only) A list of table fields and index fields that allows you to add or remove fields from the index.
Note: While selecting fields to be added to a local index of a partitioned table, the list of fields must include all the fields defined in the partition policy details and in the same order.
Descending (Add Index only) When selected, rows are sorted in decreasing order.
Ascending (Add Index only) When selected, rows are sorted in increasing order. (This option is selected by default.)