Build an index on trim(firstname)+" "+lastname and another on DELETED() and tell us what happens.

José


>>>I have a parameterized view in my form's DataEnvironment that's taking 10 seconds to create in the dodefault() of OpenTables.
>>>
>>>When I reboot (to clear the cache) and run the exact same SQL statement at the command window, it takes < 1 second.
>>>
>>>Any Ideas??
>>
>>If you are running provate datasessions, you must specify the deleted setting in the init or beforeopentables of the DE. It sounds like possibly you have set deleted on in the DE, and off in the default DS.
>
>
>Thanks for your help, Erik, but I realize now that my assumptions were wrong. It turns out that the view is 10 times slower when it includes a calculated field.
>
>I had << trim(firstname)+" "+lastname as fullname >> in my view; I suppose now I'll have to add the fullname field into my base table and use field-level validation in the .DBC to maintain it.