![]() ![]() ![]() If you have AUTO_UPDATE_STATISTICS option turned on for the database the query optimizer will automatically determine when statistics might be out-of-date and then update them when they are used by a query. The query optimizer uses them to create query plans that improve query performance. Statistics are lightweight and small objects which describe how data in SQL Server tables are distributed. If you care about SQL Server performance you need to take SQL Server Statistics into account. ![]()
0 Comments
Leave a Reply. |