The number of index segments is affected by the page size of the data file. See the
Btrieve API Guide for more information on how to use the PAGESIZE keyword. The maximum number of indexes you can create for a table depends on the page size of its data file and the number of segments in each index. As Table
42 shows, data files with page sizes smaller than 4096 bytes cannot contain as many index segments as a data file with a page size of 4096. The number of index segments that you may use depends on the file’s page size.
In Status Codes and Messages book, see status codes “26: The number of keys specified is invalid” and “29: The key length is invalid” for related information about index segments and the transactional interface.
When you create an index, you can assign to it a set of qualities, or attributes. Index attributes determine the modifiability of the index and how Pervasive PSQL sorts the indexes you define for a table. You can include parameters specifying index attributes anytime you create or alter an index definition.