>In your select statement add NOFILTER clause. There is a possibility you're creating a filtered result set. That's from the first quick glance.

and you imagine vfp creates a temp index for the whole table to fulfill the order clause ? Not impossible, but suspect... At least an interesting idea ;-)

regards

thomas