• 465789psw (9/3/2009)


    hard to tell, we need the qry plan. The engine should run one then run the 2 sec one then add them together.

    No. When you combine views (or a view with other objects) the optimiser resolves the query plan using the component parts of the view(s) - effectively ignoring the view itself and building up from the base tables.