Indexing of table columns serves two purposes:

• it speeds up searches on the table when the search is done on the content of the indexed column(s), and
• it can impose a  UNIQUE constraint on the indexed column(s) to ensure non-duplication of the contents of the simple or compound column(s).

However the indexes should be used sparingly, as they tend to consume amounts of disk space comparable in size to the space occupied by the table data itself.

This view enables the definition of Indexes for any given template. The Indexed fields scrollable area shows all fields available for indexing for the given template. The Common fields can be indexed as part of the Common template only and its settings are subsequently inherited by all Extra templates.

To define an index:

• Press the Add button (this will load the first Index default description).
• Drag all applicable fields above the Drag fields above this line instruction in the Indexed fields area.
• Rename the default description in the Name field of the Indexed fields area (this is optional).
• To make the Index unique (only a single occurrence of the defined data combination permitted), set the Unique switch to Yes.
• To create another Index for the same template, repeat the process.

Go to:
Index
Table of Contents
Global Template - Topics of Interest
Subledger Template - Topics of Interest
Transaction Template - Topics of Interest