>>According to the SYS(3054) function, everything is optimized.
>
>Are you using SYS(3054,11)? I have been "tricked" into thinking views were optimized by looking at just SYS(3054,1). The 11 arg will tell you if FoxPro is using indexes when the tables are joined (avoid "cartesian joins"). On a couple views I was able to improved view speed by two orders of magnitude by simply re-arranging the order of tables in the FROM ... JOIN clause.


This may have helped a bit, but even when the joins were optimized, or there were no joins, the SQL's were still too slow.