You are here: Commands > Index

Index

Menu: Found in the DATA menu

Use the Index command to create an index file that allows direct access to the records of a table in a logical rather than physical order. You can have more than one index file relating to a particular table. At any one time only one index file can be active.

Note: The Index command cannot be used within a Group command in a procedure.

Note: The Index key(s) cannot exceed 255 characters

For additional information, see Index.

When working with keyed data sources on an Arbutus Server, Analyzer indexing will not be available. Analyzer will automatically use the native index on the host system directly. For more information on native keys see Native and Key Fields.

Indexing versus Sorting

Sort Order

Activating and De-Activating Indexes

Indexing Tips

Filters and Conditions

Parameters

Creating an Index

Command Mode Syntax