You this not understanding.
I have a table with 38 fields and 140,000 lines. OK.
When I give to one create view and I request the inclusion of it and VFP delays 4 minutes to show its structure.
If after servant, (with filter código=10, that she only goes to present 1 register), it takes the 4 minutes to present. Already in SPT this is very fast. I do not know the reason to delay in such a way to create view (in log of the server select was carried through in 0.001 seconds).
The problem is in the creation of the structure of view and not in the data that it shows. This already this proven.
Cordialmente,
Fabiano Costa