Timeline for Enable Auto Update Stats in Async mode
Current License: CC BY-SA 3.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 8, 2016 at 2:28 | comment | added | Tara Kizer | Yes it will take affect on every table. The impact is whether or not you want the query to continue if SQL thinks updating stats will make it faster, or if you want the query to continue without the updated stats but still run update stats for other queries. That's what async does: current query continues without the benefit of updated stats, but the benefit there is that it doesn't have to wait. It can be good or bad. I don't like to rely on auto update stats, either sync or async. I like to manage statistics with UPDATE STATISTICS instead. | |
| Nov 8, 2016 at 2:22 | comment | added | Karan Salvi | Yes that method is already followed but if we turn on the auto-update stats with async for an entire database, it is obvious that it will be applicable to each and every tables isn't it? Also what would be its impact on the database ? | |
| Nov 8, 2016 at 2:06 | history | answered | Tara Kizer | CC BY-SA 3.0 |