Use Index

Create index file for a composite table as using index can increase performance.

Click CTX -> Index -> New to enter the following Index window:

Name: The index name.

Hash Length: The length of a hash index.

Filter Expression: The condition according to which the filtering operation is performed. It can be absent; default is to retrieve the whole set.

Index Type: Types of indexes include full-text index, hash index and ordered index.

Indexed Fields: Fields on which the index is created.

Value Fields: For an ordered index created on the indexed fields, the corresponding value fields will be written to it, too.

Set Indexed Fields:

Click Execute button to finish creating the index.

Click CTX -> Index -> View Data to view the created index.