sqlfriends (4/16/2013)
I have a view, if we runs it individually in SSMS, it runs ok, but we have a batch process at night that uses it for each individual. so overall it makes the process slow.
You've tested and benchmarked and confirmed that the view is absolutely the problem with the batch process?
Now we change the view to hopefully speed it up. But I would like to compare with older version ,
which version runs faster. By running both of them in SSMS, I cannot see much difference, is there a way to see which view cost less time?
Run the queries, compare the execution characteristics (via Profiler or the statistics settings). The plan's costings do not tell you how long it will run.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability