![]() Why is that?ĭo I need to set Auto create statistics to False first, before deleting these stats? The command ran successfully, but when I refresh SSMS, I can still see the _WA_sys stats there. ![]() What I want to try is, get rid of some of the _WA_sys stats and try running the queries. In many of our performance issues, my theory is, due to these _WA_sys stats, we are not getting the plan, we expect from the query. Recently we have migrated to SQL 2008 from Many of those columns are part of an index (but not the leading column). ![]() On certain tables, we have _WA_sys statistics generated on many columns. On one of our main databases, Auto Create statistics is set to True. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |