There can be as many indexes as needed. Indexes are maintained by the system as the database evolves. Items can be indexed by any field (real or calculated) in the item. The create-index command is used to create an index. When the file is changed, the indexes also change. For example, if an item is deleted, all index entries that point to that item are also deleted.
FlashBASIC programs can reference the indexes by employing the root statements. Indexes also are used by the AQL commands select, sselect, and sort if there is an index corresponding to the sort or select keys.
See Also