Hi to you all,
We have this table created by sql remote data view. It's an exact copy of the table on an oracle server, 155 fields. Data types are Character, Numeric and DateTime only. Rec count is over 33,600 records.
Using vfp5, the following SQL takes less than half a second, whereas in vfp6 it takes over 15 secs. any ideas why will be greatly appreciated. We're trying to migrate from 5.0 to 6.0

SELECT DIST FY FROM TABLE ORDER BY FY INTO CURS ACURSOR

Alberto