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 |
|
smh6n
Starting Member
3 Posts |
 Posted - 2008-10-07 : 15:09:46
|
| I ran the database tuning advisor on a stored procedure that is used often and is slow in returning results. The advisor came up with a number of recommendations, three indexes to create, and 20 or so create statistics. I've not familiar with the create statistics command. If I run it won't I need to maintain it somehow or does the Autoupdate statistics option do it? We have the database set to autoupdate statistics and autocreate statistics. Anything else one should be wary of with creating statistics? Thank you |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Database tuning recommendations