Table scan (TBSCAN) with partition pruning.
使用分区修剪的表扫描(TBSCAN)。
TBSCAN (7), (11), and (15) can also be ignored.
TBSCAN(7)、(11)和(15)也可以忽略。
This optimization is described in the TBSCAN descriptor.
在TBSCAN描述符中描述了此优化。
TBSCAN (10) initializes the local variables in the function.
TBSCAN(10)初始化函数中的本地变量。
Table space scan (TBSCAN) with stage-1 and stage-2 predicates.
使用阶段1和阶段2谓词的表空间扫描(TBSCAN)。
TBSCAN(18) represents the RETURN statement in the SQL Table function.
TBSCAN(18)表示这个SQL表函数中的RETURN语句。
TBSCAN (7) as the outer of the join provides the list of items to the function.
TBSCAN(7)是该连接的外表，它为函数提供产品列表。
TBSCAN: Retrieves rows by reading all required data directly from the data pages.
TBSCAN：通过直接从数据页中读取所有必要的数据来检索行。
The access path shows that a TBSCAN operation is performed over the table CUST_ORDER_HEADER.
访问路径显示在表cust_order_header上执行一个TBSCAN操作。
The details regarding the data flow can be found in the attributes section of the TBSCAN descriptor.
有关数据流的细节可在TBSCAN描述符的属性部分中找到。
Since the OUTER of this NLJOIN, TBSCAN (2), is applying local predicates, you must also add the predicates to the count query.
因为该NLJOIN的outer即t BS CAN(2)应用于局部断言，必须将该断言增加到计数查询。
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节点的描述符显示在访问路径图的左侧。
Now, accumulate both the inner and outer to generate the query at MSJOIN (6), that is, FILTER (10) and TBSCAN (9) (same as TBSCAN (7)).
现在，把inner和outer累积起来生成MSJOIN(6)上的查询，即FILTER(10)和TBSCAN(9)(与TBSCAN(7)相同)。
Based on guideline (c), you can ignore a separate count query for TBSCAN (4) as the join predicate being resolved is the same as in NLJOIN (2).
按照原则(c)，可以忽略tbs CAN(4)的单独count查询，因为解析的连接断言和NLJOIN(2)相同。
Because the inner table is scanned with TBSCAN, which does not guarantee the expected order for MSJOIN, a SORT node is added to enforce the order.
因为通过TBSCAN扫描内部表，即不能对MSJOIN保证预期的顺序，所以添加sort节点来执行顺序。
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)分析出的相同，并且没有其他局部断言，可以忽略该操作。
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)。
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)估计的筛选因子是否合理，应该分别对每个断言生成计数。
The earlier access plan shows that the total cost of the SELECT statement is 3420.41 timerons, which is from the table scan operator (TBSCAN) against the ACCOUNT table.
前面的访问计划显示select语句的总成本是3420.41timerons，这来自于表扫描操作符(TBSCAN)对ACCOUN t表进行的操作。
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到头九个分区。
Start from the leftmost deepest operator, in this case, the OUTER of NLJOIN(2) which is TBSCAN(2), and the INNER which is TBSCAN(4), and then the join predicate itself which is NLJOIN(2).
从最左侧、最深的操作开始，在这里就是NLJOIN(2) 的OUTER即TBSCAN(2)，然后INNER 即 TBSCAN(4)，最后是连接断言本身即 NLJOIN(2)。
Start from the leftmost deepest operator, in this case, the OUTER of NLJOIN(2) which is TBSCAN(2), and the INNER which is TBSCAN(4), and then the join predicate itself which is NLJOIN(2).
从最左侧、最深的操作开始，在这里就是NLJOIN(2) 的OUTER即TBSCAN(2)，然后INNER 即 TBSCAN(4)，最后是连接断言本身即 NLJOIN(2)。
应用推荐