We will, however, update statistics for them.
然而,我们将会为其更新统计数据。
Update statistics is run only on logged databases.
统计数据更新只能在启用了日志的数据库上执行。
Using the "reorgchk update statistics" command.
使用“reorgchkupdate statistics”命令。
Perform DB2 reorgchk on all the tables to update statistics.
在所有表上执行DB 2reorgchk来更新统计数据。
Version 1: To UPDATE STATISTICS for the entire database.
版本1:用于整个数据库的UPDATE statistics。
You cannot run UPDATE STATISTICS against an external table.
不能针对一个外部表运行update STATISTICS。
The UPDATE STATISTICS command is not executed automatically.
UPDATE STATISTICS命令不会自动执行。
Run the command UPDATE STATISTICS HIGH against the database.
对数据库运行命令update STATISTICS HIGH。
For the rest of the table, the update statistics command is NO-OP.
对于其他的表,不会执行update statistics命令。
Run the update statistics command to create or refresh statistics.
运行update statistics命令,创建或者更新统计。
List: Provides the actual "Execution Command" to run update statistics.
List:提供用来运行统计数据更新的命令。
This example shows why UPDATE STATISTICS has to be run periodically.
这个例子表明为什么必须定期运行UPDATE STATISTICS。
Version 4: to UPDATE STATISTICS for a stored procedure in a database.
版本4:用于数据库中某个存储过程的UPDATE STATISTICS。
Version 2: To UPDATE STATISTICS for a particular table in a database.
版本2:用于数据库中特定表的UPDATE STATISTICS。
What do you mean by executing UPDATE STATISTICS on a stored procedure?
在存储过程上执行update STATISTICS是什么意思?
Version 5: To perform UPDATE STATISTICS by setting your own resolution.
版本5:通过设置自己的分辨率执行update STATISTICS。
What is the ideal mode that I should use for the Update Statistics command?
用于Update Statistics命令的理想模式是什么?
Informix V11.7 introduces an AUTOMATIC mode of operation for update statistics.
Informix V11.7为update statistics引入了AUTOMATIC操作模式。
For example, you could run the update statistics command daily instead of weekly.
例如,可以每天而不是每周运行update statistics命令。
The number of rows in a table, as of the most recent UPDATE STATISTICS statement.
从最新的UPDATE statistics语句起,表中的行数。
The auto Update Statistics feature is the subject of a later article in this series.
AutoUpdate Statistics特性是本系列后面一篇文章的主题。
The value 0 disables automatic update statistics operation (original server behavior).
如果为0 ,则禁用自动升级统计(原始服务器行为)。
UPDATE STATISTICS should be run after initially loading the data and creating indexes.
初次装载数据和创建索引之后,应该运行UPDATE STATISTICS。
To populate the distribution of data, run UPDATE STATISTICS in the medium or high mode.
为了填充数据分布,以medium或high模式运行UPDATE STATISTICS。
So, DBAs tend to reduce the frequency of running update statistics to avoid the overhead.
因此,DA通常会降低运行update statistics的频率来避免系统开销。
Had you executed the UPDATE STATISTICS statement, it would have been much more efficient.
但是,如果执行了UPDATE STATISTICS语句,那么效率就会高得多。
Consider a typical scenario where the importance of UPDATE STATISTICS can be demonstrated.
考虑一个典型的场景,这个场景可以演示UPDATE STATISTICS的重要性。
You can use this section to create new tables, set a filter to tables, or run update statistics.
您可以使用这个部分创建新表、设置表过滤器或运行更新统计数据。
AUTO means to use AUTOMATIC mode of update statistics thereby enforcing smarter statistics.
AUTO意味着使用AUTOMATIC模式的update statistics,从而执行智能统计。
Query optimization is crucial in dealing with databases, and UPDATE STATISTICS does just that.
在处理数据库时,查询优化至关重要,而UPDATE STATISTICS正是用于此目的。
应用推荐