Part 3: The 32-Bit Drivers : The Btrieve (Pervasive.SQL) Driver : Indexes

Indexes
If you define an index using the Btrieve driver, the index will not have the restrictions discussed here.
For query optimization, the Btrieve driver does not use the following:
The Btrieve driver only uses an alternate-collating-sequence (ASC) index key for equality lookups. Additionally, if an ASC key is part of a segmented index, the other index segments are not used for query optimization unless the Where clause contains an equality condition for the ASC key.

© 2013 Progress Software Corporation and/or its subsidiaries or affiliates.