• When the optimizer can choose a star join plan.

    优化器何时可以选择星型连接计划。

    youdao

  • The order of indexes is chosen by the optimizer.

    索引的顺序由优化器选择。

    youdao

  • By default, the optimizer considers this type of scan.

    默认情况下,优化器考虑这种类型的扫描。

    youdao

  • The choice of the access method is left to the optimizer.

    选择访问方法的任务交给优化器来完成。

    youdao

  • The following explains why the optimizer would add a SORT node.

    以下解释了为什么优化器将添加SORT节点。

    youdao

  • Another way to influence the optimizer is to use query directives.

    影响优化器的另一种方式就是使用查询命令。

    youdao

  • Multiple index scans in the optimizer are another big win for OLTP.

    优化器中的多索引扫描是OLTP的另一大赢点。

    youdao

  • The sort heap size is used by the optimizer in determining access paths.

    优化器用排序堆大小来确定存取路径。

    youdao

  • A query access plan similar to the following is chosen by the optimizer.

    优化器会选择类似如下所示的查询访问计划。

    youdao

  • For example, the optimizer must determine whether indexes should be used.

    例如,优化器必须确定是否应使用索引。

    youdao

  • A value of -1 means that the optimizer determines the degree of asynchrony.

    若该选项值为- 1,则意味着优化器自行决定异步程度。

    youdao

  • The estimated costs are cost units that the optimizer uses to compare query plans.

    估算成本是优化器用来比较查询计划的成本单元。

    youdao

  • The important information used by the optimizer for a tablespace is the following.

    下面是优化器为表空间所使用的重要信息。

    youdao

  • Therefore the optimizer is aware of the different frequencies of the available models.

    因此,优化器清楚各种已有型号出现的不同频率。

    youdao

  • As you can see, the optimizer creates a virtual table to process the IN-list sub-query.

    如您所见,优化器创建了一个虚拟表来处理in列表子查询。

    youdao

  • The value ANY allows the optimizer to determine the number of ATQs for a given query plan.

    值ANY允许优化器决定一个给定查询计划的 ATQ的数量。

    youdao

  • The lower this value is the more likely the optimizer will choose to scan the grid index.

    这个值越低,优化器就越有可能选择扫描网格索引。

    youdao

  • Note: Here is a query for which the optimizer cannot consider using the functional index.

    注意:优化器不会对下面这个查询使用函数索引。

    youdao

  • The inconsistent statistics may also mislead the optimizer into choosing a bad access path.

    不一致的统计数据还会误导优化器选择糟糕的访问路径。

    youdao

  • This can happen when the optimizer does not have the necessary information at planning time.

    如果优化器在计划时没有必要的信息就会造成这种情况。

    youdao

  • You can use the following command to tell the optimizer to not use any optimization profile.

    可以使用以下命令告诉优化器不要使用任何优化配置文件。

    youdao

  • Goal directives that force the optimizer to use the designated rules to return query results.

    目标指示,强制优化器使用指定的规则来返回查询结果。

    youdao

  • Keep in mind that this catalog data is what the optimizer USES to make access path decisions.

    请记住,优化器使用编目数据决定访问路径。

    youdao

  • For example, what if the two local predicates are not as selective as estimated by the optimizer?

    例如,如果这两个本地谓词选择性没有优化器评估的强,怎么办?

    youdao

  • In other words, the optimizer overestimated the selectivity of the local predicates on the table.

    换句话说,优化器过高估计了本地谓词对表格的选择性。

    youdao

  • Analyze the query access plan to visualize the choices the optimizer makes in accessing the data.

    分析查询访问计划,从而可以切实看到优化器对访问数据作出的选择。

    youdao

  • As a consequence, the optimizer usually makes sub-optimal decisions, leading to poor performance.

    因此,优化器常常作出非最优决策,从而导致低劣的性能。

    youdao

  • Instead, the optimizer gathers up-to-date statistics on every database table referenced in a query.

    相反,优化器将对查询中引用的每个数据库表收集最新的统计数据。

    youdao

  • At each operator in the access plan, the optimizer estimates the cardinality output from the operator.

    对于访问计划的每个操作符,优化器将估计该操作符的基数输出。

    youdao

  • Keyword 'ANY' : This setting indicates that MQTs will be considered by the optimizer to process queries.

    关键字'ANY ':该设置表明MQT将被优化器考虑来处理查询。

    youdao

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

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

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