仅指定那些谓词中所使用的列。
每个引用表中使用了哪些种类谓词?
指定查询谓词(where子句)。
包含所有行;没有谓词。
注意完全相同的谓词。
谓词顺序什么时候会造成差异?
谓词放在方括号 [和 ] 中。
本部分介绍参数化谓词语法。
根据关系谓词和xml谓词进行过滤。
谓词的选择性越强,应该越早应用谓词。
The more selective the predicate, the earlier the predicate should be applied.
有时,谓词顺序没有差别。
谓词也是资源。
操作是应用程序的谓词。
要记住,谓词作用于谓词本身左侧的节点集。
Remember, a predicate applies to the node set to the left of the predicate itself.
参数化谓词是xslt谓词映射的输入文档。
The parameterized verb is the input document for the XSLT verb mapping.
减少谓词。
有两种类型的设计器谓词:全局谓词和局部谓词。
因此,可以使用like谓词作为模糊联结谓词。
The LIKE predicate can therefore be used as a fuzzy join predicate.
仅当第一个谓词认为行不合格时第二个谓词才应用。
The second predicate is applied only when the row is disqualified by the first predicate.
确保MQT应用的谓词是查询应用的谓词的一个子集。
Make sure that the predicates applied by the MQT are a subset of the predicates applied by the query.
谓词的工作原理类似于:对于每个节点,引擎使用上下文处理谓词。
The predicates work like this: for each node, the engine processes the predicate using that context.
在那个谓词中,还可以再次向下钻取,以添加另一个谓词。
Within that predicate, you might drill down again to add another predicate.
重新排序和重新组合谓词是基于谓词的种类(本地或联接)和表引用。
Predicates are reordered and regrouped based on the kind of predicate (local or join) and the table reference.
您需要使用本地谓词和连接谓词设计索引,以支持高效访问。
You need to design indexes to support efficient access with local predicates and join predicates.
在创建新任务查询谓词时,请考虑创建相应的电子邮件谓词。
When creating new staff query verbs, consider the creation of a corresponding E-mail verb.
其他的非db2自动提供的,而又能提供谓词传递闭包的本地谓词。
Additional local predicates that are not automatically provided by DB2 that can provide predicate transitive closure.
如果您想相似谓词先于列表谓词应用,则您的编码顺序必须相应反映。
And if you want the like predicate applied before the in-list predicate, your coding order must reflect that.
如果存在此谓词,将使用该谓词并将接收与升级接收者谓词相同的参数。
If this verb exists, it will be used and it will receive the same parameters as the escalation receivers verb.
该索引包含实际字符串的散列值,只能用于等式谓词,不能用于范围谓词。
This index contains hash values of the actual strings and can be used for equality predicates only, not for range predicates.
联结和用户谓词的结果应该以(联结)AND(用户谓词)的形式组合在一起。
The result of the join and user predicates should be ANDed together in the form (joins) and (user predicates).
应用推荐