We will, however, update statistics for them.
然而,我们将会为其更新统计数据。
Using the "reorgchk update statistics" command.
使用“reorgchkupdate statistics”命令。
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:提供用来运行统计数据更新的命令。
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命令。
You can use this section to create new tables, set a filter to tables, or run update statistics.
您可以使用这个部分创建新表、设置表过滤器或运行更新统计数据。
These features impact and improve the way update statistics collects information for the optimizer.
这些特性将影响并改善update statistics为优化器收集信息的方式。
Prior to IBM Informix V11.7, when you ran the update statistics command, statistics were always recreated.
在IBMInformixV11.7 之前,当运行update statistics命令时,统计数据总是会重新创建。
New features in IBM Informix V11.7 let you dramatically improve the performance of running update statistics.
IBMInformixV11.7中的新特性使您能够极大地改善运行update statistics的性能。
When STATCHANGE is set in a session, it affects the tables on which update statistics is run in that session.
当在会话中设置STATCHANGE后,它将影响该会话中在其上运行update statistics的表。
Tables and indexes with changes less than the imposed STATCHANGE are completely skipped during update statistics.
在update statistics期间,数据修改小于所设置的STATCHANGE的表和索引将被直接跳过。
In our first improvement to the benchmark, let us add an index on the bills table and update statistics for the table.
在我们对基准的第一个改进中,我们向账单表增加索引,并为表更新统计信息。
Note: The AUTO and FORCE keywords work with ALL modes of update statistics and have no effect on procedure statistics.
注意:AUTO和FORCE关键字需在update statistics的ALL模式下使用,并且不会对程序统计产生影响。
These values are then used by consecutive update statistics runs to determine if existing statistics are good or stale.
连续运行的update statistics将使用这些值来判断现有的统计数据是否过时。
The effect of smarter statistics can be quite profound on the amount of time it takes to update statistics on large systems.
智能统计可以极大地缩短对大型系统更新统计数据所需的时间。
The runstats utility can be used to update statistics in system catalog tables to facilitate the query optimization process.
可以使用runstats实用程序来更新系统编目表中的统计信息,使查询优化过程更容易一些。
This is a major improvement over scattering calls to update statistics and to track context throughout my example application.
比起在整个示例应用程序中用分散的调用更新统计值和跟踪上下文,这是一个重大的改进。
You can use the AUTO and FORCE keywords in the update statistics command to specify if Smarter statistics should be used or not.
可以在update statistics命令中使用AUTO和FORCE关键字,指定是否需要使用智能统计。
To update statistics on all the tables or a group of tables in DB2, you can use the REORGCHK command with the update statistics option.
要对DB 2中所有表或一组表的统计信息进行更新,可使用REORGCHK命令以及UPDATE STATISTICS选项。
Have you ever wondered if the update statistics command you are about to run is actually needed since the last time you updated statistics?
自从最近一次更新过统计数据后,您是否想过您将要运行的update statistics命令是否真正必要?
Many customers new to Informix do not realize they must update statistics, and see poor performance due to the lack of optimizer statistics.
许多Informix新客户没有认识到他们必须更新统计数据,因此由于缺少最新的优化器统计数据,他们的数据库性能很差。
The Auto Update Statistics (AUS) component of OAT is used to simplify the work of the DBA by running the update statistics command based on specific policies.
OAT 的AutoUpdate Statistics (AUS)组件根据特定的策略运行统计数据更新命令,从而简化DBA的工作。
However, it does not easily offer the flexibility of running multiple concurrent scripts to update statistics against different sets of tables in the same database.
但是它不能灵活地运行多个并发脚本,来在同一数据库中根据不同的表来更新统计数据。
The output file generated by the Design Advisor contains a set of DDL statements that create MQTs, refresh and update statistics on the MQTs, and create indexes on them.
Design Advisor生成的输出文件包含一组ddl语句,用于创建MQT、刷新和更新MQT上的统计信息,以及在其上创建索引。
With the smarter statistics feature, you can now configure the server to automatically detect and refresh only stale statistics when you run the update statistics command.
通过使用智能统计特性,您可以对服务器进行配置,从而在运行update statistics命令时自动检测并刷新已过时的统计数据。
For example, it automatically executes the RUNSTATS utility on a periodic basis to update statistics about the physical characteristics of a table and the associated indexes.
例如,它周期性地自动执行RUNSTATS实用程序,以更新关于表及相关索引的物理特征的统计信息。
Even if you configure and enable Smarter statistics, the AUTO and FORCE enhancements to update statistics command allows you to specify if only stale or all statistics should be refreshed.
即使您配置并启用了智能统计,update statistics命令的AUTO和FORCE增强允许您指定是否对过时的统计或全部统计进行刷新。
These updatable views allow you to update certain statistical information to investigate the performance of a hypothetical database, or to update statistics without using the RUNSTATS utility.
这些可更新的视图允许更新某些统计信息,从而研究假想数据库的性能,或者更新统计信息而不使用RUNSTATS实用程序。
应用推荐