pseudo-index

For SQL data sources, a current index can be defined as any group of fields from a specific table, whether or not a corresponding index exists on the server. BDE creates a pseudo-index by using one or more user-specified SQL fields to define the requested order.

You can specify the pseudo-index even if there is a real index matching the behavior of the pseudo-index. When specifying the pseudo-index, BDE behavior is the same as it would be if the physical index existed on the server. In particular, DbiSetRange and DbiGetRecordForKey are allowed on a pseudo-index. DbiSetToBegin, DbiGetNextRecord, and so on, walk through records in the order implied by a pseudo-index.

For information on implementing pseudo-indexes, see DbiOpenTable or DbiSwitchToIndex.