Indexing Data


Indexing is a field property setting that tells the database that a field needs to be used to create an index.

  • Fields that will be commonly sorted, queried, or filtered will likely be indexed
  • It’s an internal processing that controls how much data must be looked at when processing the data for queries
  • makes data processing faster
  • some fields are automatically indexed when they are created
    • e.g., key fields
  • can confirm whether a field is indexed or not in the back-end database
    • need edit permissions for the database to change the properties
  • too many indexes can slow performance