Now that the view injects the filter predicate at the SQL level, DB2 can take advantage of the usual database techniques, that is index access.
现在，该视图在sql级注入过滤谓词，DB 2可以利用通常的数据库技术，即索引访问。
Since it is a range predicate and there are no frequency and histogram statistics available, the filter factor is calculated with the basic statistics information HIGH2KEY and LOW2KEY.
由于它是范围谓词，而且没有频度和直方图统计数据可用，过滤因子是用基础统计信息HIGH2KEY和LOW2KEY计算得出的。
This approach requires the federated system to retrieve a superset of the data referenced by the predicate from the remote data source, and then filter it locally against the predicate.
这种方法要求联邦系统首先从远程数据源获取由谓词引用的数据的一个超集，然后通过谓词在本地对其进行过滤。
The estimate for QUALIFIED_ROWS is obtained by multiplying the table cardinality (560,273 records) by the predicate filter factor (0.0014%).
用表基数（560,273条记录）与谓词过滤因子 (0.0014%) 相乘就获得了 QUALIFIED_ROWS的估计值。
The Filter factor for each predicate indicates the proportion of data the optimizer estimates will satisfy the predicate.
每个断言的筛选因子表示优化器估计符合断言的数据的比例。
This is the same join predicate applied at FILTER(10).
和应用于FILTER(10) 的连接断言相同。
The filter factor is a number between 0 and 1 that estimates the proportion of rows in a table for which the predicate is true.
过滤因子是0到1之间的一个数值，它用来评估表中谓词为真的行所占的比例。
To understand how the optimizer ends up with 0.0014% as the filter factor, first look at the six elements in the IN list predicate.
为了了解优化器如何最终以 0.0014％作为过滤因子，首先要查看在IN清单谓词上的6 个元素。
The Where method takes a predicate that determines whether the given element should be selected, and it produces a stream of elements that pass the filter.
Where方法用了一个谓语来确定是否选择给定元素，并且生成一些可通过过滤器的元素。
FF (see number 6 in Figure 5) : Filter factor for the predicate.
FF(见图5中6)：谓词的过滤因子。
The filter method in Listing 9 accepts a list and a criteria (a code block specifying how to filter the list) and iterates over the list, adding each item to a new list if it matches the predicate.
清单9中的filter方法接受了一个list和一个criteria(指定如何过滤列表的代码块)并对列表进行遍历，将满足谓语的项添加到一个新列表中。
The query annotation for this predicate shows that the predicate filter factor (FF) is 0.000014, or 0.0014%.
此谓词的查询注释显示谓词过滤因子(FF)是0.000014，或0.0014%。
If you want to further see if the filter factor estimates at TBSCAN (3) make sense, you should generate a count for each predicate individually. For example.
如果希望进一步看看TBSCAN(3)估计的筛选因子是否合理，应该分别对每个断言生成计数。
The filter factor indicates how selective the predicate is.
过滤因子表示谓词的选择性有多强。
Notice that once again, we used a shorthand closure for the predicate function passed to the filter function.
请再次注意，我们为传递给filter函数的断言函数使用了一个简短的闭包。
The filter function applies the predicate, and if it returns true, the element in the sequence is added to the result.
filter函数被应用到这个断言，如果该断言返回true，序列中的元素就被加到此结果。
In this dissertation, psychoacoustic models filter Banks quantization and bit allocation predicate coding and temporary noise shaping is analyzed.
本文首先对心理声学模型、滤波器组、量化和比特分配、预测编码、时域噪声成型等技术进行研究。
In this dissertation, psychoacoustic models filter Banks quantization and bit allocation predicate coding and temporary noise shaping is analyzed.
本文首先对心理声学模型、滤波器组、量化和比特分配、预测编码、时域噪声成型等技术进行研究。
应用推荐