![]() select is_auto_create_stats_on, is_auto_update_stats_on from sys.databases There are many environments where I have seen that AUTO CREATE STATS and AUTO UPDATE STATS is turned on, and that’s the default too. The optimizer relies heavily on statistics to produce an efficient execution plan.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |