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 |
|
andriancruz
Starting Member
38 Posts |
 Posted - 2009-05-21 : 02:11:35
|
| Dear expert,Is it possible to drop/remove from the statistics all start from _dta_stat and _dta_index. I already execute the DROP STATISTICS but only _WA_sys can removed. Is there a way remove all those things. If not what is the effect in the database and why the statistics continue creating. Any advice and explanatio will highly appriciated. Thank in Advance...Best regards,Andrian |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-05-26 : 12:19:37
|
| There are statistics for indexes and non-index statistics. You cannot drop the statistics created by indexes manually. Any index whether index based or not is updated automatically as data is changed, this is the default and recommended setting. Unless you have a very very heavy OLTP load where stats updates are causing performance issues, you dont need to disable them. Having them is a good thing and will benefit queries. The indexes with _WA are system created indexes.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2009-05-27 : 09:38:53
|
| I think (but can't be absolutely sure) that the _dta indexes and statistics are from the Database Tuning Advisor. I think they can be dropped safely, but if I were you, I would get a little more confirmation on that point.The _WA entries are automatically created statistics. These are created when the database is set to AUTO_STATS, and a user queries with that column in a where clause. The statistics do not take up a lot of room, and it is generally advisable to leave these alone. |
|
|
|
andriancruz
Starting Member
38 Posts |
Posted - 2009-05-29 : 02:12:33
|
| Thank you for the reply. Now I understand. |
|
|
|
|
|
|
Index Statistics