A really weird problem. I have a Foxdos table with some simple indexes stored in a CDX file.

orderno index on orderno
custno index on custno
trandate index on trandate

Here is the weird part. I try and run a SQL against the table in VFP9 and it is slow. I check with SYS(3054) and it says optimized is none. My SQL is very simple such as.

Select *;
From testtable;
Where orderno="1234"

Yet if I change the above field from orderno to trandate it becomes fully optimized. So VFP9 can use Rushmore from Dos, but not on strings.

Any ideas on what I might be missing.

TIA,
Dale