I have a table than when queried uses no rushmore optimization according to sys(3054,1). the same table queried in 2.6 (DOS), vfp 6.0 and vfp 8.0 all uses rushmore. Are there any known issues with rushmore optimization in vfp 9.0?
I used the following code:

use policy in 0
lcpolicynum = '12345'
select * from policy where cpolicynum = lcpolicynum into array myarray


i have an index tag on cpolicynum. This table has 85000 records in it. the query takes over 30 seconds in vfp 9. but takes 0 seconds in dos and vfp 6 and 8

any suggestions?