>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??
Darren,

Yes, there are no indexes on DELETED() and the form is using set deleted on while the command window has set deleted off.