Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
imarchenko
Yak Posting Veteran
57 Posts |
 Posted - 2009-09-25 : 19:02:57
|
| Hello! I am using SQL Server 2005 64 bit Standard Edition. One of the processes I inherited selects all records from the view. View is quite complicated and built on top of other views/tables. A couple of days ago process has started running extremely slow. Step that retrieves data from the view has been running for hours (instead of usual 40-50 min) and I had to stop the job. I was trying to improve performance of the view. I recompiled/refreshed view updated statistics on base tables, etc. But performance is still horrible. Any advice is greatly appreciated.Thanks,Igor |
|
|
Vinnie881
Master Smack Fu Yak Hacker
1231 Posts |
Posted - 2009-09-27 : 11:31:47
|
You will need to make sure that on all SUB-VIEWS that the tables used are properly indexed.
Success is 10% Intelligence, 70% Determination, and 22% Stupidity.\_/ _/ _/\_/ _/\_/ _/ _/- 881 |
 |
|
|
|
|
|
view performance has deteriorated