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.
Table of Contents
Global Template - Topics of Interest
Subledger Template - Topics of Interest
Transaction Template - Topics of Interest