In VFP9 the Rushmore is turned off for character indexes if CPDBF() doesn't match CPCURRENT().
>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
>
--sb--