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 |
|
reddy_vam
Starting Member
43 Posts |
 Posted - 2008-11-06 : 15:43:07
|
| Hi Folks,I want to update statistics on all database views in a server, by using sp_updatestats i can update statistics on all database tables only but not on the views.Thanks in Advance, |
|
|
cvraghu
Posting Yak Master
187 Posts |
Posted - 2008-11-06 : 23:57:20
|
| You can update the statistics for table and INDEXED Views only. Not all Views. Read BOL. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-07 : 09:32:34
|
| Most important is you need to update Stats for underlying tables in view and Update if its not. |
|
|
|
|
|
|
How to update statistics on all database views