Hello folks,
In all my years of working with VFP, having a first...rushmore is not working for every table. This is a new Win7 machine with VFP9 on it.
For some queries on certain tables, it all works perfectly.
The test queries are simple; sys(3054) reveals rushmore optimization of "none".
select * from ediinvoicelnes where invnum = "1055947"
select * from ediinvoices where invnum = "1055947"
Of course there is an unfiltered index on invnum in each table, and SET OPTIMIZE is ON. The data is sitting out on the network (W2K Server, don't laugh...no SMB2). I compiled the test into an .exe and ran it from outside "Program Files" to make sure there was no funny business going on there, same result.
These queries run fine (optimized) on the machine sitting next to it (WinXP, VFP8).
Any ideas? About to copy these tables locally to see if the network is to blame, but that is a stretch.
Thanks,
Steve Gibson