过滤因子表示谓词的选择性有多强。
直方图用于计算谓词的选择率。
Histograms are used to calculate the selectivity of the predicates.
使用适于XML连接谓词的索引。
多个本地等式和本地in谓词的统计关联。
Statistical correlation of multiple local equality and local IN predicates.
使用匹配谓词的索引扫描(IXSCAN)。
谓词的选择性越强,应该越早应用谓词。
The more selective the predicate, the earlier the predicate should be applied.
高级监测模型根据关联谓词的值匹配入站事件。
The inbound event is matched by the high-level monitor model according to the value of the correlation predicate.
xml索引至少包含了满足谓词的所有xml节点。
The XML index contains at least all XML nodes that satisfy the predicate.
它将返回那些满足所有谓词的文档的行id。
It returns the row IDs of those documents that satisfy all of these predicates.
以下查询明确地将连接谓词的两端转换为DOUBLE。
The following query explicitly casts both sides of the join predicate to DOUBLE.
确保MQT应用的谓词是查询应用的谓词的一个子集。
Make sure that the predicates applied by the MQT are a subset of the predicates applied by the query.
下面浏览一下表1中的行,来研究每个谓词的索引合格性。
Now step through the rows in Table 1 to explore index eligibility for each predicate.
URLScan 禁止任何不使用这些谓词的请求。
使用阶段1和阶段2谓词的表空间扫描(TBSCAN)。
Table space scan (TBSCAN) with stage-1 and stage-2 predicates.
列组的使用将给多个谓词的联合选择提供更准确的估计。
The use of column groups provides more accurate estimates of the joint selectivity of multiple predicates.
已经分析了本地谓词的选择性,我们再看看表的选择性。
Now that you've analyzed the selectivity of the local predicates, let's now look at the table selectivity.
下面是优化器不会考虑为其检测统计关联的谓词的例子。
The following are some examples of predicates that are not considered for statistical correlation detection by the optimizer.
如果有用于两个谓词的索引,则可以参看图2中的计划(c)。
If you have indexes for both predicates you may see execution plan (c) in Figure 2.
您传递一个用作谓词的公式,检查它是否是一个有效的元素规则。
You pass a formula used as a predicate to see if it is a valid rule for the element.
重新排序和重新组合谓词是基于谓词的种类(本地或联接)和表引用。
Predicates are reordered and regrouped based on the kind of predicate (local or join) and the table reference.
这个例子解释说明了列组统计信息对一个合格的OR谓词的影响。
This example illustrates the effect of column group statistics on a qualifying OR predicate. Consider the following query on the EMPLOYEE table.
将联结操作符应用于左右属性的表达式,从而产生联结谓词的表达式。
Generate the expression for the join predicate by applying the join operator to the expressions for the left and right attributes.
考虑在联邦服务器上,而不是在远程数据源上执行的选择谓词的影响。
Consider the effect of a selective predicate being evaluated at the federated server instead of at the remote data source.
优化器使用频率统计信息来计算用于检查相等或不等的谓词的过滤因子。
Frequency statistics are used by the optimizer to calculate filter factors for predicates that check for equality or inequality. For example.
上面定义的两个索引都适合用于客户姓名上的xmlexists谓词的计算。
Both indexes defined above are eligible to evaluate the XMLEXISTS predicate on the customer name.
此外,DB 2要求遵从基本的语法规则,以检测潜在的对空间谓词的使用。
Additionally, DB2 requires that you follow a basic syntax rule in order to detect the potential application of a spatial predicate.
根据各种标准,如本地谓词或连接谓词,以及表引用来定制谓词的格式化顺序。
Customize the formatting ordering of the predicates according to various criteria such as local predicates or join predicates, and table references.
联结和用户谓词的结果应该以(联结)AND(用户谓词)的形式组合在一起。
The result of the join and user predicates should be ANDed together in the form (joins) and (user predicates).
丢失的统计数据会让优化器高估或低估谓词的选择性,最终会选择低效的访问路径。
Missing statistics can cause the optimizer to overestimate or to underestimate the selectivity of a predicate, and eventually to select an inefficient access path.
XQuery没有类似于关系查询中 “between”谓词的专用功能或操作符。
XQuery does not have a special function or operator similar to the relational "between" predicate.
应用推荐