• The optimizer will choose dynamic hash join if none of the joined columns has index.

    如果连接列上不存在索引,那么优化器将选择动态哈希连接。

    youdao

  • This is a lot faster than a nested loop join of two table scans without any index usage.

    这比不使用任何索引的两个表扫描的嵌套循环连接要快得多。

    youdao

  • If there is an index on the join column, the costs will be significantly less; otherwise the database server must perform table scans for all tables, both outer and inner tables.

    如果连接列上有一个索引,那么其成本会相当低;否则,数据库服务器就必须对所有表(外部和内部表)执行表扫描。

    youdao

  • The guideline specifies that table SECURITY should be the outer table in the join and the XML index SEC_INDUSTRY should be used to access the SECURITY table.

    该准则指定应当将表SECURITY 作为连接中的外表,而XML索引 SEC_INDUSTRY 应当被用于访问 SECURITY 表。

    youdao

  • The number of rows retrieved from the outer table after the database server applies any table filters is small, and the inner table has an index that can be used to perform the join.

    在数据库服务器使用所有表筛选器之后,从外部表检索出的行数将很少,而内部表具有一个可用于执行连接的索引。

    youdao

  • The optimizer will then join that temp table to the fact table using the compound index to quickly locate the rows that satisfy the criteria on the dimension tables.

    优化器然后使用复合索引将临时表连接到事实表,来快速定位在维度表中满足条件的行。

    youdao

  • You can define guidelines that influence only a few attributes of an execution plan, such as index specification for a certain table in the query or join order for a pair of tables.

    可以定义那些只影响执行计划的某些属性的准则,比如查询中的某个表的索引说明,或者一对表的连接顺序。

    youdao

  • The location_id join keys that meet the filter requirements on the Location dimension table are pushed down to the index on the Orders table.

    Location维度表中满足过滤条件的 location_id连接键被下推至Orders 表的索引。

    youdao

  • Building bitmap join indexes of dimension tables and fact tables directly may bring a large number of useless index items that affect query efficiency.

    直接建立维度表与事实表的位图连接索引会产生大量无用的索引项,影响查询效率。

    youdao

  • You have a join logical file, but only want the index for the key on SSD, not the secondary indexes.

    您有一个连接逻辑文件,但是只希望在SSD中保存键的索引,而不是二级索引。

    youdao

  • This join method is usually used when no index is available on the join columns for the joining tables.

    当连接表的连接列上没有可用索引时,通常使用该连接方法。

    youdao

  • To summarize the advice for XML join queries, always cast join predicates to the type of the XML index that should be used.

    总结一下关于XML连接查询的建议,通常将连接谓词转换为应使用的xml索引类型。

    youdao

  • The guideline also specifies that the table CUSTACC should be the inner table of the join and the XML index ACC_CURRENCY should be used to access the CUSTACC table.

    准则还指定应当将表CUSTACC作为连接的内表,而xml索引acc_currency应当用于访问custacc表。

    youdao

  • The result set from FETCH (3) is ordered by the ID column and joined using a merge join with index I1 for T1 to get final result set.

    FETCH(3)的结果集是根据ID字段排序的,并且使用T1的索引I1的合并联接而得到最终的结果集。

    youdao

  • In addition, DB2 can leverage new query and join operators, as well as new index processing techniques, to provide strong runtime performance for queries involving XML documents.

    另外,DB 2可以利用新的查询和联结操作符以及新的索引处理技术,为涉及XML文档的查询提供更好的运行时性能。

    youdao

  • From the performance perspective, this is considered a very efficient join operation, because the cost for scanning the inner table is optimal via unique access through a unique index.

    从性能的角度来看,这被认为是一个非常有效的联接操作,因为通过贯穿唯一索引的唯一访问扫描内部表的成本是最优的。

    youdao

  • As shown in the IXSCAN descriptor in Figure 8, the leading column of the index exploited by optimizer is PRODUCT_NUMBER, which does not provide the order required for merge scan join.

    如图8的IXSCAN描述符所示,通过优化器利用的索引的领先列是PRODUCT _ NUMBER,其不为合并扫描联接提供所需的顺序。

    youdao

  • There is a nested loop join (NLJOIN, step 4) of the insert (step 5) to an index scan (IXSCAN, step 7).

    其中有一个insert(步骤5)与索引扫描(步骤7)之间的嵌套循环连接(NLJOIN,步骤4 )。

    youdao

  • In the previous section you learned about one type of access method, index scan (IXSCAN), and one type of join method, nested loop join (NLJOIN).

    在之前的部分您已经了解了一种类型的访问方法,即索引扫描(IXSCAN),和一种类型的联接方法,即嵌套循环联接(NLJOIN)。

    youdao

  • Gather counts for base accesses (an index scan or a table scan of a table) that are not dependent on a join.

    收集不依赖于连接(JOIN)的基本访问(表的索引扫描和表扫描)的计数。

    youdao

  • The pushed-down join keys can be used in an index pushdown or a bit-vector push-down.

    下推连接键可用于索引下推或位向量下推。

    youdao

  • A new feature of the query optimizer supports a new type of index scan, called an index self-join path.

    查询优化器的一项新特性支持一种新的索引扫描,即索引自连接路径。

    youdao

  • It is rare in an OLTP query for the lookup tables to be selected as the primary query tables requiring an index on the dependent table to support the join.

    OLTP查询中很少需要选择查找表作为需要相关表上的索引来支持联接的主查询表。

    youdao

  • International companies have equal opportunities to join key market indices, thereby creating a natural international shareholder base among index tracking and active investors alike.

    国际上的公司也有同样的机会参与股指市场,进而在股指追踪和类似的活跃投资人中,形成了一个自然的国际股东基础。

    youdao

  • Next month, its shares join a revamped Straits Times Index, which could boost long-term interest in the company.

    而该公司股票下个月还将成为新版海峡时报指数的成份股,其长期投资价值将因此得到进一步提升。

    youdao

  • Next month, its shares join a revamped Straits Times Index, which could boost long-term interest in the company.

    而该公司股票下个月还将成为新版海峡时报指数的成份股,其长期投资价值将因此得到进一步提升。

    youdao

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

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

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