For each table reference in the query, query Tuner adds the following annotations.
对于查询中的每个表引用，QueryTuner会添加以下注释。
Predicates are reordered and regrouped based on the kind of predicate (local or join) and the table reference.
重新排序和重新组合谓词是基于谓词的种类(本地或联接)和表引用。
Another potential problem is the local predicate on the table reference CUST_ORDER_HEADER (COHE) in the inner sub-query (see also in Figure 9).
另一个潜在问题是内部子查询中CUST_ORDER_HEADER (COHE)表引用上的本地谓词(见图9)。
To the right of each table reference is the table cardinality (in terms of both number of records and number of pages) and the estimated number of qualified rows.
每个表引用的右边是表基数(依据记录的数量和页面的数量)以及合格行的估计数量。
The number associated with QUALIFIED_ROWS represents the estimated number of records that would qualify all the local predicates of the underlying table reference.
与 QUALIFIED_ROWS相关的数代表将使基础表引用的所有本地谓词合格的估计的记录数量。
According to the annotation information in the figure, the table reference CUST_CUSTOMER (CCUS) has two local predicates which are very selective, with filter factor 0.00727 and 0.004, respectively.
根据图中的注释信息，优先表CUST_CUSTOMER (CCUS)有两个本地谓词，其选择性很强，各自的过滤因子分别是0.00727和0.004。
According to the annotation information in the figure, the table reference CUST_CUSTOMER (CCUS) has two local predicates which are very selective, with filter factor 0.00727 and 0.004, respectively.
根据图中的注释信息，优先表CUST_CUSTOMER (CCUS)有两个本地谓词，其选择性很强，各自的过滤因子分别是0.00727和0.004。
应用推荐