A have several remote views fetching the data from MSSQL 7, all of them performing 4 to 6 left outer joins and having 5 to 8 AND'ed parameters.

The problem: one of those views takes TOO MUCH time to open with NODATA option (3-4 minutes), others are ok (I have the same delay when creating view definition, i.e. 'create sql view ... as...' causes 3 minutes delay).
I moved the definitions to the server (created server views w/out parameters) and reduces VFP definitions to 'select * from /server_view_name/ where /parameter_list/' - that didn't help.

Q1: Could somebody point me to an explanation of how VFP internally parses pre-defined views so I could localize the problem ?
Q2: Is it possible at all to work with large view definitions on VFP/MSSQL platform without using pass-through/MSSQL stored procedures?

P.S. Actually, when I redefine views both on VFP and MSSQL, the VFP view opens instantly for the first 3-4 times, then comes the delay... Anything to do with MSSQL view parameters?