过滤因子表示谓词的选择性有多强。
直方图用于计算谓词的选择率。
Histograms are used to calculate the selectivity of the predicates.
使用适于XML连接谓词的索引。
“between”谓词的索引支持。
FF(见图5中6):谓词的过滤因子。
FF (see number 6 in Figure 5) : Filter factor for the predicate.
多个本地等式和本地in谓词的统计关联。
Statistical correlation of multiple local equality and local IN predicates.
谓词的选择性定义如下。
使用匹配谓词的索引扫描(IXSCAN)。
按照您想应用索引列谓词的顺序创建您的索引。
Create your indexes in the order in which you want those index column predicates applied.
高级监测模型根据关联谓词的值匹配入站事件。
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.
允许任何使用未在此节中出现的谓词的请求。
Any requests that use verbs that do not appear in this section are permitted.
它将返回那些满足所有谓词的文档的行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.
索引的数据类型与查询谓词的数据类型相匹配。
The data type of the index matches the data type in the query predicate.
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.
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.
应用推荐