If you instruct the database engine not to automatically maintain statistics , you must manually update the statistical information 如果指示数据库引擎不要自动维护统计信息,则必须手动更新统计信息。
Value will frequently help you determine when to update statistics because the behavior is reasonably close to the results of earlier versions 值通常可帮助您确定更新统计信息的时间,因为该行为与早期版本的结果相当接近。
Statistics can be created or updated on tables with computed columns only if the conditions exist in which an index can be created on these columns 仅当存在能对计算列创建索引的条件时,才可以对包含计算列的表创建或更新统计信息。
The update statistics statement re - enables automatic statistical updating on the target table or view unless the norecompute clause is specified Update statistics语句会重新启用对目标表或视图更新统计信息,指定了norecompute子句时除外。
The drawback in this method is that it does not do as good a job of reorganizing the data as an index rebuild operation , and it does not update statistics 此方法的缺点是在重新组织数据方面不如索引重新生成操作的效果好,而且不更新统计信息。
Statistics can be created on specific table or view columns by using the create statistics statement , and updated by using the update statistics statement 可以使用create statistics语句对特定表或视图列创建统计信息,并使用update statistics语句更新统计信息。
Table , and turns off automatic statistics updating for the statistics group collection . use adventureworks ; go update statistics production . product products with fullscan , norecompute ; go 中的所有行进行完全扫描,并关闭统计信息组(集合)的自动更新统计信息功能。
In some cases , after you set auto update statistics to on , the process of updating statistics may affect server performance of queries when statistics are first referenced 在某些情况下,将auto _ update _ statistics设置为on后,第一次引用统计信息时,更新统计信息的过程可能会影响查询的服务器性能。
You can control the amount of data that is sampled during manual statistics updates on a table - by - table basis by using the sample and fullscan clauses of the update statistics statement 可以使用update statistics语句的sample子句和fullscan子句,控制按逐个表的方式手动更新统计信息时采样的数据量。