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: 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描述符的属性部分中找到。
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节点的描述符显示在访问路径图的左侧。
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)估计的筛选因子是否合理,应该分别对每个断言生成计数。
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到头九个分区。
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到头九个分区。
应用推荐