Indexing in EMu
To facilitate the search of large numbers of records, indexes are built that provide rapid access to data that match given search criteria. Indexes provide an indirect means of searching data in a judicious manner: when a search term is entered, the indexes are consulted to produce the matching records. There is a cost associated with indexing: the need to store indexing information along with the data.
There are a large number of indexing methods available to designers of databases, each one with associated pros and cons. The
- The first is known as linear hashing and provides high speed key retrieval.
- The second goes by the long name of A two level superimposed coding scheme for partial match retrieval, (shortened to the Two Level method) and provides a general purpose framework for implementing a wide range of term based searches. A term is simply a sequence of characters that forms the basic entity for searching. For example, in word based searching (where you need only enter a word to find matching records), a term is a word.
A number of pre-configured indexing options are distributed with
It is possible to adjust indexing via Registry entries. These entries allow institutions to tune indexing methods to provide the most efficient searching possible without wasting disk space on unused methods.
Users in group Admin can use an Admin Task to view indexing information:
The View System Indexing Admin Task allows users to view information about indexing set on
To run the task:
- Click in the Command Centre to open the Admin Tasks module.
This lists all tasks grouped by module:
The Admin heading at the top of the list is for a virtual module that includes all tasks unrelated to a specific module.
- Under Admin, select View System Indexing.
The output of the task is similar to:
As there may be a large number of tables in some institutions the Admin Task may take some time to process all of the information (up to ten minutes for a large system). The indexing information may also contain columns that are not used by your institution. These columns are sub-classed columns specific to a particular client. Enabling indexing on these columns does not affect the size of the indexes generated as empty fields do not generate any indexing information (unless null based indexing is enabled).
By default, users in group Admin have access to this task. If other users need to run the script, add the following Admin Task Registry entry:
Group
|
group | Table
|
eadmin
|
Admin Task
|
View System Indexing
|
|
where group is the name of the group that requires access.
Details about Indexing are available in Indexing in EMu
Improved indexing methods
Several indexing methods were added to the database engine with a*
). System Administrators are able to configure which fields require these indexing methods using the
Tools that permit System Administrators to tune the range indexing used by