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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only