Field Index is a data structure that provides rapid location of keys in database systems or other computer systems. Field Index provides quick access to data for specific key values. Field Index generally uses a B-tree (binary tree) or a derivative data structure of a B-tree.

Create Index for one or more fields in the Dataset to help quickly find and sort data.

Function entrance

• Start tab-> Data Processing-> Field Index.

Parameter Description

In the Dataset Field Index dialog, set the Parameters:

• Source Data: Select the Datasource where the Dataset requiring Create Index is located and the Dataset requiring Create Index.
• Index: Complete field selection and index creation in the Index area:
  • Index List: The list lists the Field Index names created by the Current Data set. The main information includes Index Name and Fields That Created Index.
    • Index Name: The index name used to identify this field. The name is relatively unique.
    • Fields That Created Index: Shows the fields in the current index.
  • Create: Click the "Create" button, check one or more fields requiring Create Index in the pop-up dialog box, and click the "OK" button to select the field Create Index. You can create a joint index for the selected field, which is applicable to the case of Query Conditions for multiple fields.
  • Delete: Select the field to be deleted and click the "Delete" button. "No" will be displayed in the corresponding position of the "Index Created" column, indicating that there is no Create Index in the current field.
  • Modify: Select a record in the index list to delete or add the Index Field in the Index Name.