A field index is a data structure in database systems or other computer systems that enables rapid key-value positioning. It provides fast access capabilities to data with specific key values, typically implemented using B-tree (binary tree) or its derivative data structures.

Create indexes for one or multiple fields in the dataset to enhance search and sorting performance.

Feature Entry

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

Parameter Description

Configure parameters in the "Dataset Field Index" dialog:

• Source Dataset: Select the datasource containing the target dataset and choose the dataset requiring index creation.
• Index: Complete field selection and index operations in the "Index" section:
  • Index List: Displays all field indexes created for the current dataset, including:
    • Index Name: Unique identifier for the field index.
    • Indexed Fields: Shows fields included in the current index.
  • Create: Click to select one or multiple fields for index creation. Multiple selections create a composite index, suitable for queries with multiple field conditions.
  • Delete: Select target fields and click to remove indexes. The "Index Created" column will display "No" for deselected fields.
  • Modify: Select any index record to add or remove indexed fields within the index name.