For large data sets and where performance is a critical objective it may be required to tune PhixFlow to improve speed and performance.
Indexing
- Indexes are applied to attributes on a table and help improve the speed of data retrieval when handling large data sets
- Users do not see the indexes, they are used internally by PhixFlow
- Updating a table with indexes takes more time than one without, as the indexes also need to be updated
- Indexes should only be created on attributes that will be frequently searched against
See Indexed on Attribute.