• Table scan (TBSCAN) with partition pruning.

    使用分区修剪的表扫描(TBSCAN)。

    youdao

  • TBSCAN (7), (11), and (15) can also be ignored.

    TBSCAN(7)、(11)和(15)也可以忽略。

    youdao

  • This optimization is described in the TBSCAN descriptor.

    在TBSCAN描述符中描述了此优化。

    youdao

  • TBSCAN (10) initializes the local variables in the function.

    TBSCAN(10)初始化函数中的本地变量。

    youdao

  • Table space scan (TBSCAN) with stage-1 and stage-2 predicates.

    使用阶段1和阶段2谓词的表空间扫描(TBSCAN)。

    youdao

  • TBSCAN(18) represents the RETURN statement in the SQL Table function.

    TBSCAN(18)表示这个SQL表函数中的RETURN语句。

    youdao

  • TBSCAN: Retrieves rows by reading all required data directly from the data pages.

    TBSCAN:通过直接从数据页中读取所有必要的数据来检索行。

    youdao

  • The access path shows that a TBSCAN operation is performed over the table CUST_ORDER_HEADER.

    访问路径显示在表cust_order_header上执行一个TBSCAN操作。

    youdao

  • The details regarding the data flow can be found in the attributes section of the TBSCAN descriptor.

    有关数据流的细节可在TBSCAN描述符的属性部分中找到。

    youdao

  • In Figure 2, the descriptor for the table node and the descriptor for the TBSCAN node are shown to the left of the access path graph.

    在图2中,表节点的描述符和TBSCAN节点的描述符显示在访问路径图的左侧。

    youdao

  • TBSCAN (4) — Since this is the same join predicate being resolved at NLJOIN (2), and there are no additional local predicates, we can ignore this operator.

    TBSCAN(4)——因为这个连接断言和NLJOIN(2)分析出的相同,并且没有其他局部断言,可以忽略该操作。

    youdao

  • As was mentioned in the previous article, for single table access, there are two types of access methods: table space scan (TBSCAN) and index scan (IXSCAN).

    在第1部分中提到过,有两种类型访问方法:表空间扫描(TBSCAN)和索引扫描(IXSCAN)。

    youdao

  • If you want to further see if the filter factor estimates at TBSCAN (3) make sense, you should generate a count for each predicate individually. For example.

    如果希望进一步看看TBSCAN(3)估计的筛选因子是否合理,应该分别对每个断言生成计数。

    youdao

  • Because there is a predicate, cust_order_number between 100000 and 580000, on the partitioning column, the optimizer is able to limit the TBSCAN to the first nine partitions.

    因为有一个谓词,cust_order_number处于100000到580000之间,在分区列上,优化器能够限制TBSCAN到头九个分区。

    youdao

  • Because there is a predicate, cust_order_number between 100000 and 580000, on the partitioning column, the optimizer is able to limit the TBSCAN to the first nine partitions.

    因为有一个谓词,cust_order_number处于100000到580000之间,在分区列上,优化器能够限制TBSCAN到头九个分区。

    youdao

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

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

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