Index Editor

The Index Editor allows you to edit the index fields and other index properties. It is available on creating a new index or editing the existing one (see Create Index and Edit Index for details).

Index Name
Name of the index; must be unique among the index names in the table.

Fields for Index
Select fields to include in the index by moving them from the Available Fields list box to the Selected Fields.

To move the selected fields click the arrow buttons ( > or < ), drag the selected fields or double-click the required field. To select multiple fields, hold down the Shift or Ctrl key while selecting the field names.

   Primary
Makes index a primary key.

   Unique
Makes index unique.

   Case-insensitive
Make index case-insensitive.

Order
Defines the index sorting type.

Compression
Sets the index compression: Full (default), None, Duplicate-byte, or Trailing-byte.

See also:

Table Editor