GilaMonster (4/16/2013)
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.
Yes, we changed the view at first to accommdate other data change, it slows down the night process. That is why we know it is the view. Then we tried to optmimize the view.