optimizer
英 [ˈɒptɪmaɪzə]
美 [ˈɑptəˌmaɪzər]
n. 优化程序（进行优化工作的程序）
复数：optimizers
双语例句
- You can create, save, and reuse external optimizer directives.
可以创建、保存和重用外部优化器指令。 - The optimizer can decide to not use an index even if it could be used.
优化器可以决定不使用索引，即使该索引是可以使用的。 - New optimizer directives and session environment controls are also introduced for influencing optimizer consideration of star join optimization.
新的优化器指令和会话环境控制因为影响优化器对星型连接优化的考虑，所以文中也包含了它们的介绍。 - Accurate index information and statistics are fundamental to cost-based decisions in the query optimizer.
准确的索引信息和统计信息是查询优化器中基于成本的决策的基础。 - The optimizer uses data distribution information generated by UPDATE STATISTICS to calculate selectivity for the filters in the query.
优化器使用UPDATESTATISTICS所生成的数据分布信息来计算查询中筛选器的选择性。 - This means the optimizer will always attempt to formulate an access path for each query that reduces overall cost.
这意味着优化器将始终尝试为每个查询制定减少总体成本的存取路径。 - The makers of Zend also have a commercial opcode cache that includes an optimizer to further increase efficiency.
Zend的厂商也提供了一种商业操作码缓存，包括一个进一步提高效率的优化器。 - As you can see, the optimizer creates a virtual table to process the IN-list sub-query.
如您所见，优化器创建了一个虚拟表来处理IN列表子查询。 - This command updates the statistics in the system catalogs that the optimizer uses to determine the lowest-cost query plan.
此命令更新了系统目录中的统计数据，优化程序使用这些数据来确定成本最低的查询计划。 - Relationships between tables provide valuable input to the Teradata database optimizer.
表之间的关系提供了Teradata数据库优化器的输入值。 - In this article, you have taken a look at the use of distribution statistics by the DB2 optimizer.
在本文中，您看到了DB2优化器对分布统计信息的使用。 - DB2 UDB comes with a powerful cost-based query optimizer that determines the best strategy to access data.
DB2UDB中包含了一个功能强大基于成本的查询优化器，用于确定访问数据的最佳策略。 - DB2's cost-based optimizer uses these statistics to generate efficient execution plans for XQuery and SQL/ XML queries.
DB2基于成本的优化器使用这些统计信息为XQuery和SQL/XML查询生成有效的执行计划。 - The DB2 optimizer uses these characteristics and restrictions when determining the best way to process a query.
DB2优化程序使用这些特征和限制来确定处理一个查询的最佳方法。 - DB2's cost-based optimizer decides which table to scan and which table to access through the index.
DB2的基于成本的优化器决定了要扫描的表以及通过索引要访问的内容。 - These views include columns containing statistical information that is useful to the query optimizer.
这些视图包括一些包含对查询优化器有用的统计信息的列。 - Comparing real cardinalities to the optimizer's estimates can help you identify query planning problems.
对真实的基数和优化器估计的基数进行比较，可以帮助您识别出查询计划方面的问题。 - In other words, the optimizer overestimated the selectivity of the local predicates on the table.
换句话说，优化器过高估计了本地谓词对表格的选择性。 - The optimizer can use data distributions to calculate selectivity for the filters in a query.
优化器可以使用数据分布来计算查询中过滤器的选择率。 - Text search is integrated into SQL and optimized by the DB2 optimizer for run time.
文本搜索集成到SQL中，DB2优化器在运行时会对它进行优化。 - This example illustrates the effect that partial statistics have on the ability of the optimizer to estimate the cardinality.
这个示例解释说明了部分统计信息对于优化器估计基数的能力的影响。 - Another way to influence the optimizer is to use query directives.
影响优化器的另一种方式就是使用查询命令。 - The optimizer is equivalent in function to an expert system.
优化器在功能上等价于一个专家系统。 - We also propose to use a hybrid version of PSO embedding a local optimizer to enhance the performance.
我们也建议使用混合动力版本的粒子群优化嵌入局部优化，以提高其性能。 - Without a favourable query optimizer, even if a minitype database behaves remarkable low performance.
如果没有设计良好的查询优化器，即使是小型的数据库也会表现出非常明显的性能低下。 - If necessary, the optimizer adds a work table to the execution plan to ensure this.
如果必要，优化器将向执行计划添加一个工作表以确保该实现。 - The query optimizer must analyze the possible plans and choose the one with the lowest estimated cost.
查询优化器必须分析可能的计划并选择一个预计成本最低的计划。 - Indicates that column statistics which would have been useful to the query optimizer are not present.
表明不存在可能对查询优化器有用的列统计。 - Automatic Internet, PC and Registry Optimizer. It's safe. It's easy.
自动因特网，PC和注册表优化器。它是安全的。它是容易的。 - It is used to make decision by optimizer of relational database management system ( RDBMS).
关系数据库管理系统（RDBMS）是一种技术成熟、应用十分广泛的系统。