有两个局部断言。
为了查看这两个局部断言的实际计数,生成一个count查询。
For the two local predicates, to see what the real count is, generate a count query.
因为该NLJOIN的outer即t BS CAN(2)应用于局部断言,必须将该断言增加到计数查询。
Since the OUTER of this NLJOIN, TBSCAN (2), is applying local predicates, you must also add the predicates to the count query.
TBSCAN(4)——因为这个连接断言和NLJOIN(2)分析出的相同,并且没有其他局部断言,可以忽略该操作。
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.
在OPERATORS(8)和(7)上没有任何局部或连接断言。
At OPERATORS (8) and (7), you are not applying any local or join predicates.
在OPERATORS(8)和(7)上没有任何局部或连接断言。
At OPERATORS (8) and (7), you are not applying any local or join predicates.
应用推荐