• Alerts: Provides details regarding tables missing "statistics update".

    Alerts提供缺少统计数据更新详细信息。

    youdao

  • 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

    youdao

  • 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昵称统计信息更新程序不断更新它们

    youdao

  • You can use this section to create new tables, set a filter to tables, or run update statistics.

    可以使用这个部分创建设置过滤器运行更新统计数据

    youdao

  • In our first improvement to the benchmark, let us add an index on the bills table and update statistics for the table.

    我们基准的第一个改进我们账单增加索引更新统计信息

    youdao

  • This is a major improvement over scattering calls to update statistics and to track context throughout my example application.

    比起在整个示例应用程序中用分散调用更新统计值跟踪上下文一个重大改进

    youdao

  • Two ways to update statisticswithout dropping of objects dependent on the nickname — are outlined below.

    下面给出更新统计信息两种方法——删除依赖于昵称的对象

    youdao

  • The database server does not update the statistics in the system catalog tables.

    数据库服务器更新系统编目中的统计信息

    youdao

  • Hence, the update statements to update the statistics can fail with the SQL1227N error message.

    因此,用于更新统计数据update语句可能失败并产生SQL 1227n错误消息。

    youdao

  • Tip: Update the database statistics regularly.

    提示定期更新数据库统计数据

    youdao

  • This map is used subsequently when JDBC statements are executed to update statistics for the appropriate request.

    随后执行jdbc语句更新对应请求统计值使用这个

    youdao

  • The database server automatically issues the UPDATE statistics statement to recalculate routine statistics for all SPL routines that reference the table.

    数据库服务器自动发出UPDATE STATISTICS语句引用该表所有SPL重新计算例统计信息。

    youdao

  • The effect of smarter statistics can be quite profound on the amount of time it takes to update statistics on large systems.

    智能统计可以极大地缩短大型系统更新统计数据所需时间

    youdao

  • AUTO_STAT_MODE: Has a default value of 1, which enables the automatic update statistics operation (fragment-level statistics is on).

    AUTO_STAT _ MODE:一个默认1支持自动升级统计操作(片段级统计为ON时)。

    youdao

  • Update statistics is run only on logged databases.

    统计数据更新只能启用了日志的数据库上执行。

    youdao

  • Perform DB2 reorgchk on all the tables to update statistics.

    所有执行DB 2reorgchk更新统计数据

    youdao

  • 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工作

    youdao

  • OpenAdmin Tool provides support for \ most of the IDS 11 features MACH 11, Auto update statistics.

    OpenAdmin Tool大部分IDS11特性MACH 11自动更新统计数据提供支持

    youdao

  • 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命令自动检测刷新过时的统计数据。

    youdao

  • Use UPDATE STATISTICS LOW if the number of rows has changed significantly or after migration from previous version of database server.

    如果更改很多,或者不同版本的数据库服务器之间完成迁移,则应使用UPDATE STATISTICSLOW

    youdao

  • The optimizer USES data distribution information generated by UPDATE STATISTICS to calculate selectivity for the filters in the query.

    优化使用UPDATE STATISTICS所生成数据分布信息计算查询筛选器选择性

    youdao

  • So it is obvious that the accuracy of selectivity estimation depends upon how often you run UPDATE STATISTICS.

    因此选择性估算准确性显然基于运行UPDATE STATISTICS的频率。

    youdao

  • The value 0 disables automatic update statistics operation (original server behavior).

    如果为0则禁用自动升级统计原始服务器行为)。

    youdao

  • AUTO means to use AUTOMATIC mode of update statistics thereby enforcing smarter statistics.

    AUTO意味着使用AUTOMATIC模式update statistics从而执行智能统计

    youdao

  • These features impact and improve the way update statistics collects information for the optimizer.

    这些特性将影响改善update statistics优化收集信息方式

    youdao

  • 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选项

    youdao

  • So, DBAs tend to reduce the frequency of running update statistics to avoid the overhead.

    因此DA通常降低运行update statistics频率避免系统开销。

    youdao

  • Tables and indexes with changes less than the imposed STATCHANGE are completely skipped during update statistics.

    update statistics期间,数据修改小于设置的STATCHANGE索引将被直接跳过

    youdao

  • New features in IBM Informix V11.7 let you dramatically improve the performance of running update statistics.

    IBMInformixV11.7中的特性使能够极大地改善运行update statistics性能

    youdao

  • Query optimization is crucial in dealing with databases, and UPDATE STATISTICS does just that.

    处理数据库时,查询优化至关重要,UPDATE STATISTICS正是用于此目的。

    youdao

$firstVoiceSent
- 来自原声例句
小调查
请问您想要如何调整此模块?

感谢您的反馈,我们会尽快进行适当修改!
进来说说原因吧 确定
小调查
请问您想要如何调整此模块?

感谢您的反馈,我们会尽快进行适当修改!
进来说说原因吧 确定