Non-matching index scan (IXSCAN)
非匹配索引扫描 (IXSCAN)
Index scan (IXSCAN) with matching predicates.
使用匹配谓词的索引扫描(IXSCAN)。
Based on guideline (a), IXSCAN (10) and IXSCAN (14) are both base accesses.
根据原则(A)，IXSCAN(10)和IXSCAN(14)都是基本访问。
From the access plan, IXSCAN (3) shows one row is expected to be returned from T1.
在上面的存取计划中，IXSCAN(3)显示T1预期会返回一行记录。
IXSCAN (14) is similar in nature. View the properties at IXSCAN (14), and notice its predicates are.
IXSCAN(14)在本质上是相似的。
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 ）。
At each IXSCAN operator, the cardinality is corrected to account for a correlation between the predicates.
对于每一个IXSCAN操作符，基数都被更正了，从而说明谓词间的关联。
Although IXSCAN (15) is a base access, it is dependent on NLJOIN (5), and so it can be ignored in the interim.
尽管IXSCAN(15)是基本访问，但是它依赖于NLJOIN(5)，所以可以忽略它。
Based on guideline (b), the cardinality does not change from IXSCAN (10) to SORT (9), where both estimate 1.17815 rows.
根据原则(B)，从IXSCAN(10)到SORT(9)基数没有改变，都是估计为1.17815行。
The IXSCAN node detailed description shows that all of the 1,680 leaf pages are scanned due to the lack of a matching predicate.
由于缺乏匹配的谓词，IXSCAN节点详细描述显示所有被扫描的1,680个叶级页。
When looking at the properties of IXSCAN (10), you can see that the predicates applied are referencing columns qualified by labels such as Q2.
在查看IXSCAN(10)的属性时，可以看到应用的断言引用了由Q2这样的标签进行限定的列。
Like the existing relational index scan operator for relational indexes (IXSCAN), the XISCAN operator performs lookups or scans on XML indexes.
类似于现有的用于关系索引的关系索引扫描操作符(IXSCAN)，XISCAN操作符在xml索引上执行查找或扫描。
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)。
Taking the predicates applied at IXSCAN (10), you can create an SQL statement to get the real-time count for the predicates applied at this operator.
得到应用于IXSCAN(10)的断言后，可以创建sql语句以获得应用于该操作的断言的实时数。
The plan segment from the access plan in Listing 2 indicates that the IXSCAN operation will return an estimated number of 4.85057 (approximately 5) rows.
清单2中的访问计划片段表明IXSCAN操作估计将返回4.85057(约5)行。
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)。
Go to this specific operator ID in the detailed operator section of the access plan, and isolate the predicates applied at the operator (in this case, IXSCAN). For example.
在访问计划的详细操作部分找到这个操作id，并隔离应用于该操作(即ixscan)的断言。
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，其不为合并扫描联接提供所需的顺序。
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，其不为合并扫描联接提供所需的顺序。
应用推荐