过滤因子表示谓词的选择性有多强。
直方图用于计算谓词的选择率。
Histograms are used to calculate the selectivity of the predicates.
使用适于XML连接谓词的索引。
多个本地等式和本地in谓词的统计关联。
Statistical correlation of multiple local equality and local IN predicates.
谓词的选择性定义如下。
使用匹配谓词的索引扫描(IXSCAN)。
高级监测模型根据关联谓词的值匹配入站事件。
The inbound event is matched by the high-level monitor model according to the value of the correlation predicate.
不使用任何这些谓词的请求将被拒绝。
谓词的选择性越强，应该越早应用谓词。
The more selective the predicate, the earlier the predicate should be applied.
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.
一个原则是禁用in谓词到连接谓词的转换。
A guideline to disable the transformation of the in predicate to a join.
以下查询明确地将连接谓词的两端转换为DOUBLE。
The following query explicitly casts both sides of the join predicate to DOUBLE.
MQT应用用户查询考虑应用的谓词的相同集合或子集。
The MQT applies the same set or a subset of predicates that the user query under consideration applies.
下面浏览一下表1中的行，来研究每个谓词的索引合格性。
Now step through the rows in Table 1 to explore index eligibility for each predicate.
使用阶段1和阶段2谓词的表空间扫描(TBSCAN)。
Table space scan (TBSCAN) with stage-1 and stage-2 predicates.
要理解这一点，查看在此谓词的查询注释上的MAXFREQ。
To understand this, look at MAXFREQ in the query annotation for this predicate.
URLScan 禁止任何不使用这些谓词的请求。
确保MQT应用的谓词是查询应用的谓词的一个子集。
Make sure that the predicates applied by the MQT are a subset of the predicates applied by the query.
您传递一个用作谓词的公式，检查它是否是一个有效的元素规则。
You pass a formula used as a predicate to see if it is a valid rule for the element.
列组的使用将给多个谓词的联合选择提供更准确的估计。
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 predicates work like this: for each node, the engine processes the predicate using that context.
下面是优化器不会考虑为其检测统计关联的谓词的例子。
The following are some examples of predicates that are not considered for statistical correlation detection by the optimizer.
xml索引定义的限制等同于或低于查询谓词的限制(“容纳”)。
The XML index definition is equally or less restrictive than the query predicate (" containment ").
若要更深入地了解电子邮件谓词的用法，请参阅第2部分。
For a deeper understanding of the E-mail verb usage, see Part 2.
重新排序和重新组合谓词是基于谓词的种类(本地或联接)和表引用。
Predicates are reordered and regrouped based on the kind of predicate (local or join) and the table reference.
也就是说，将限定此谓词的行的估计百分比是0.0014%。
That is, the estimated percentage of rows that would qualify with this predicate is 0.0014%.
下方的描述字段简要概述了所选谓词的功能和人员插件提供者支持。
The description field beneath gives a short overview of the capabilities and staff plug-in provider support of the selected verb.
它让DB 2使用索引来立即查找满足where子句中的两个简单谓词的行。
It lets DB2 use the index to immediately look up the row or rows that satisfy the two simple predicates in the WHERE clause.
应用推荐