In this case, the "Last statistics update" column is empty.
在这个例子中,“Laststatistics update”列是空白的。
Alerts: Provides details regarding tables missing "statistics update".
Alerts:提供缺少统计数据更新的表的详细信息。
The nickname statistics update facility, which allows you to update nickname statistics.
昵称统计信息更新功能,它允许更新昵称统计信息。
The new functionality is also available through more flexible options in Control Center's nickname statistics update facility, which calls NNSTAT. NNSTAT can collect statistics in one of two modes.
ControlCenter的昵称统计信息更新程序的一些更灵活的选项还提供了新功能,即NNSTAT。
Once statistics for a nickname have been initially populated by any method, they can be kept up-to-date using the NNSTAT stored procedure or Control Center's nickname statistics update facility.
不管使用何种方法,初步填充完一个昵称的统计信息之后,就可以使用 NNSTAT存储过程或ControlCenter的昵称统计信息更新程序不断更新它们。
We will, however, update statistics for them.
然而,我们将会为其更新统计数据。
You can use this section to create new tables, set a filter to tables, or run update statistics.
您可以使用这个部分创建新表、设置表过滤器或运行更新统计数据。
In our first improvement to the benchmark, let us add an index on the bills table and update statistics for the table.
在我们对基准的第一个改进中,我们向账单表增加索引,并为表更新统计信息。
This is a major improvement over scattering calls to update statistics and to track context throughout my example application.
比起在整个示例应用程序中用分散的调用更新统计值和跟踪上下文,这是一个重大的改进。
Two ways to update statistics — without dropping of objects dependent on the nickname — are outlined below.
下面给出了更新统计信息的两种方法——不删除依赖于昵称的对象。
The database server does not update the statistics in the system catalog tables.
数据库服务器不更新系统编目表中的统计信息。
Hence, the update statements to update the statistics can fail with the SQL1227N error message.
因此,用于更新统计数据的update语句可能失败并产生SQL 1227n错误消息。
Tip: Update the database statistics regularly.
提示:定期更新数据库统计数据。
This map is used subsequently when JDBC statements are executed to update statistics for the appropriate request.
随后在执行jdbc语句更新对应请求的统计值时,会使用这个图。
The effect of smarter statistics can be quite profound on the amount of time it takes to update statistics on large systems.
智能统计可以极大地缩短对大型系统更新统计数据所需的时间。
Update statistics is run only on logged databases.
统计数据更新只能在启用了日志的数据库上执行。
Perform DB2 reorgchk on all the tables to update statistics.
在所有表上执行DB 2reorgchk来更新统计数据。
List: Provides the actual "Execution Command" to run update statistics.
List:提供用来运行统计数据更新的命令。
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的工作。
The optimizer USES data distribution information generated by UPDATE STATISTICS to calculate selectivity for the filters in the query.
优化器使用UPDATE STATISTICS所生成的数据分布信息来计算查询中筛选器的选择性。
So it is obvious that the accuracy of selectivity estimation depends upon how often you run UPDATE STATISTICS.
因此,选择性估算的准确性显然基于您运行UPDATE STATISTICS的频率。
The value 0 disables automatic update statistics operation (original server behavior).
如果为0 ,则禁用自动升级统计(原始服务器行为)。
AUTO means to use AUTOMATIC mode of update statistics thereby enforcing smarter statistics.
AUTO意味着使用AUTOMATIC模式的update statistics,从而执行智能统计。
These features impact and improve the way update statistics collects information for the optimizer.
这些特性将影响并改善update statistics为优化器收集信息的方式。
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选项。
So, DBAs tend to reduce the frequency of running update statistics to avoid the overhead.
因此,DA通常会降低运行update statistics的频率来避免系统开销。
For example, you could run the update statistics command daily instead of weekly.
例如,可以每天而不是每周运行update statistics命令。
Query optimization is crucial in dealing with databases, and UPDATE STATISTICS does just that.
在处理数据库时,查询优化至关重要,而UPDATE STATISTICS正是用于此目的。
Using the "reorgchk update statistics" command.
使用“reorgchkupdate statistics”命令。
Consider a typical scenario where the importance of UPDATE STATISTICS can be demonstrated.
考虑一个典型的场景,这个场景可以演示UPDATE STATISTICS的重要性。
应用推荐