Creating complex indexes for dBASE tables

Topic group

Complex indexes on dBASE tables use a combination of one or more field names, plus valid dBL expressions. Use a complex index when no single field uniquely identifies each row, or when you need the flexibility of an expression to define the index condition.

Indexes on .DB tables also can use multiple fields; such indexes are called composite indexes. However, unlike complex indexes in dBASE tables, you cannot use functions or operators in the .DB index expression.