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. Therefore, indexes should only be created on attributes that will be frequently searched against. See Indexed on Attribute.