or Edit Index
. Both are available from context menus in the DB Structure view and from the OpenEdge Index tab of the DB Details view.
|
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.)
|