|
|
|
RECBYT indexes were introduced in the c-tree Plus ISAM API to provide improved space management for variable length records in a table and to permit backward physical traversal of data files that contain resources and variable length records. A RECBYT index is an index based on the byte offset (recbyt) of the record being indexed.
RECBYT indexes are optional and the user can disable their creation by specifying the CTCREATE_NORECBYT when a table is created.
When a table is created with RECBYT index support, a RECBYT index is automatically created for the table. The operations on the RECBYT index are transparent to the user except for additional performance overhead. c-treeDB will automatically update the index entries. The RECBYT index will not appear in the list of indexes for a table. The user cannot alter or delete the components of the RECBYT index. The use of RECBYT index has no impact on the fields in the record buffer of a table. There is no field associated with this index.
Note: The RECBYT index enables backward physical traversal of variable-length records. By default, the c-treeDB API creates this index on every table. Because it is an extra index, it slows inserts, updates, and deletes. Unless you need to walk variable-length records backwards, disable the creation of the index by adding NORECBYT to the table create mode.
