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.