您要查找的是不是:
- Use a time limit to determine when to update statistics. 使用时间限制确定更新统计信息的时间。
- Use application-level information to determine when to update statistics. 使用应用程序级信息确定更新统计信息的时间。
- Is the name of the table or indexed view for which to update statistics. 要更新其统计信息的表或索引视图的名称。
- Redirecting the output to a file to make sure all the update statistics ran fine without any problems. 将输出重定向到文件中以确保所有更新的统计数据都运行得很好,没有任何问题。
- The number of rows in a table, as of the most recent UPDATE STATISTICS statement. 从最新的UPDATE STATISTICS语句起,表中的行数。
- To run DBCC checks, back up a database and its transaction log, update statistics, and rebuild indexes. 可以运行DBCC检查,备份数据库及其事务日志以及更新统计并重建索引。
- The distribution of column values, when requested with the MEDIUM or HIGH keyword in the UPDATE STATISTICS statement. 当请求UPDATE STATISTICS语句中带有MEDIUM或HIGH关键字时,列值的分布情况。
- However, some implementations might require you to run UPDATE STATISTICS separately with the FULL SCAN option. 但是,有些实现可能要求您分别运行UPDATE STATISTICS和FULL SCAN选项。
- If index_name is supplied, SQL Server 2005 modifies the automatic UPDATE STATISTICS setting for that index. 如果提供了index_name,则SQL Server 2005将修改该索引的自动UPDATE STATISTICS设置。
- Two ways to update statistics - without dropping of objects dependent on the nickname - are outlined below. 下面给出了更新统计信息的两种方法不删除依赖于昵称的对象。
- Update the statistics of the base table by using the UPDATE STATISTICS statement. 使用UPDATE STATISTICS语句更新基表的统计信息。
- Use sqlmaint to run DBCC checks, back up a database and its transaction log, update statistics, and rebuild indexes. 使用sqlmaint,可以运行DBCC检查、备份数据库及其事务日志、更新统计以及重建索引。
- This is a major improvement over scattering calls to update statistics and to track context throughout my example application. 比起在整个示例应用程序中用分散的调用更新统计值和跟踪上下文,这是一个重大的改进。
- The Update Statistics task includes options for full scan or for sample size as was available in SQL Server 2000 maintenance plans. “更新统计信息”任务包括先前在SQL Server 2000维护计划中提供的完全扫描选项或样本大小选项。
- Against the database on the destination server to update statistics and ensure optimal performance of the copied database. 以更新统计信息并确保已复制数据库具有最佳性能。
- Update statistics - To help optimize query performance, we recommend that you update statistics on all databases following upgrade. 更新统计信息-建议您在升级之后对所有数据库更新统计信息,以便优化查询性能。
- Value will frequently help you determine when to update statistics because the behavior is reasonably close to the results of earlier versions. 值通常可帮助您确定更新统计信息的时间,因为该行为与早期版本的结果相当接近。
- For databases with a compatibility level of 90 or higher, sp_updatestats preserves the automatic UPDATE STATISTICS setting for any particular index or statistics. 对于兼容性级别为90或更高的数据库,sp_updatestats将保留任何特定索引或统计信息的自动UPDATE STATISTICS设置。
- Log in, click“ Update Space”, and click“ Update Statistical Data”. 登陆,点击“更新空间”,点击“更新统计数据”。
- For databases with a compatibility level below 90, executing sp_updatestats resets the automatic UPDATE STATISTICS setting for all indexes and statistics on every table in the current database. 对于兼容性级别低于90的数据库,如果执行sp_updatestats,将对当前数据库内每个表中的所有索引和统计信息重置自动UPDATE STATISTICS设置。