Data Table Index

For most fields, Informat automatically creates indexes based on actual usage scenarios. If business scenarios require it, database indexes can also be created separately for fields. The index types that can be created are unique indexes and ordinary indexes. Creating indexes can greatly improve query performance.

Unique index fields can use one or more fields as the unique identifier of a record. If uniqueness is not satisfied when creating or updating data, the user will be prompted and the modification will be rejected.

The following types of fields cannot be used as index fields:

• Function
• Associated record field
• Lookup list
• Associated list
• Static text
• Custom component

When an index field is deleted, the data table index associated with it will also be automatically deleted.