RE: Performance of ODBC vs. other access methods

[rob@xxxxxxxxx]

Don't forget, key order is also important in WHERE clauses.  For example, 
you may have a file with 90+% of the records have an "active record code 
field" with a value of "A" and a few records with a value of "D".  A 
simple example is an item master.  While the item number should be a 
unique key, you may also want a key with active record code and then the 
item number.  This way you can sort by the item number for all active 
records.  Maybe this is what you are seeing?

Rob Berendt