SQLServerCentral » Latest topics
huge diffence direct query vs query view
Engine: SQL Server 2008 R2 Service Pack 2 CU12 (I know, but I'm stuck with it)
When I copy the code in the view into the query, the select only needs 0sec elaps time.
Querying the view takes 20sec because it adds 2 worker tables !! ??
When I copy the code in the view into the query, the select only needs 0sec elaps time.
Querying the view takes 20sec because it adds 2 worker tables !! ??
No comments:
Post a Comment