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