You are here: Commands > Index > Activating and De-Activating Indexes

Activating and Deactivating Indexes

There are four ways to activate an index file:

• When you first create the index, make sure Open Table is checked in the Index dialog. This activates the index when the Index command is executed.
• If you want to activate an existing index, click the index in the Overview.
• If you want to activate an existing index, right-click on the index in the Overview and click OPEN.
• If you want to activate an existing index on the command line or in a procedure, issue a SET INDEX TO index_name command.

To check that an index is active, look at the left of the status bar. The window will indicate either “x Records Indexed” or “x Records Filtered Index”, depending on whether or not the index was created using a filter.

There are two ways to de-activate an index file:

• If you want to de-activate an existing index, right-click on the index in the Overview and click CLOSE.
• If you want to de-activate an existing index on the command line or in a procedure, issue a SET INDEX command.

For more information on the SET INDEX command, see Set Index.