Maintaining indexes

You can copy, rename, or delete an index in the Indexes tab of the Table Properties dialog box. You can also add additional indexes from the same location.

You can perform these maintenance tasks only through ACL. If you directly rename an index file (.inx file) in a Windows folder the index file is automatically recreated with the original name the next time you activate the index in ACL. If you directly delete an index file, the index file is automatically recreated the next time you activate the index.

To maintain an index:

  1. Open the table containing the index.
  2. Right-click the table in the Project Navigator and select Properties.
  3. Click the Indexes tab, select the index name, and do one of the following:
    • Click Copy to copy the index.

      The index is copied with an incrementing number added to the end of the index name.

    • Click Rename, enter a new name, and click OK to rename the index.

    • Click Delete, then click Delete again to delete the index.

  4. If you want to add a new index, click Add.

    The Index dialog box appears, allowing you to create an index in the usual manner.

  5. Click OK to exit the Table Properties dialog box.
Related concepts
About indexing
Related tasks
Indexing records
Activating and deactivating indexes
Viewing index details
Sorting or indexing records using computed fields


(C) 2013 ACL Services Ltd. All Rights Reserved. | Send feedback