Viewing index details

You can view the details of an index (that is, the actual syntax of the specific Index command), including the key field(s), and any parameters, filters, or expressions. Index details reveal exactly how a particular index is processing the records in a table.

To view index details:

  1. Open the table containing the index.
  2. Right-click the table in the Navigator and select Properties.
  3. Click the Indexes tab, select the index name, and click Details.

    The Index Properties dialog box displays the index details. Command: displays the syntax of the specific Index command, including any local filter. Filter: displays the syntax of any global filter that is part of the index.

  4. Click OK and OK again to exit the Table Properties dialog box.
Related concepts
About indexing
Related tasks
Indexing records
Activating and deactivating indexes
Maintaining indexes
Sorting or indexing records using computed fields

(C) 2015 ACL Services Ltd. All Rights Reserved.