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.