过滤因子表示谓词的选择性有多强。
直方图用于计算谓词的选择率。
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)。
谓词的选择性越强,应该越早应用谓词。
The more selective the predicate, the earlier the predicate should be applied.
按照您想应用索引列谓词的顺序创建您的索引。
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 data type of the index matches the data type in the query 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.
应用推荐