减少谓词。
Use indexes for XML join predicates.
使用适于XML连接谓词的索引。
Filters data based on XML predicates.
基于xml谓词过滤数据。
Skip operators with redundant predicates.
跳过带有冗余断言的操作。
Filtering on relational and XML predicates.
根据关系谓词和xml谓词进行过滤。
Index scan (IXSCAN) with matching predicates.
使用匹配谓词的索引扫描(IXSCAN)。
Wildcards in XML indexes and query predicates.
xml索引和查询谓词中的通配符。
Namespaces in XML indexes and query predicates
XML索引和查询谓词中的名称空间
Use predicates on both relational and XML data.
对关系数据和XML数据使用谓词。
Data types in XML indexes and query predicates.
xml索引和查询谓词中的数据类型。
Used for range, equality, or IN-list predicates.
用于范围、等于或in列表谓词。
But what if our non-index predicates look like this.
但如果我们的非索引谓词如下所示，情况有会怎样呢？
A note on the contradictions within XPath predicates.
关于XPath谓词中的矛盾。
Specify only those columns that are used in predicates.
仅指定那些谓词中所使用的列。
Join predicates need to be specified in the FROM clause.
需要在from子句中指定联结谓词。
However, the predicates can be statistically correlated.
但在统计方面，这些谓词可以彼此关联。
What kinds of predicates are used on each referenced table?
每个引用表中使用了哪些种类谓词？
Join predicates need to be created out of each of the joins.
需要为每个联结创建联结谓词。
Local predicates with inequality, LIKE, or IS NULL operators.
带有不等式、LIKE或IS null操作符的本地谓词。
Table space scan (TBSCAN) with stage-1 and stage-2 predicates.
使用阶段1和阶段2谓词的表空间扫描(TBSCAN)。
What if we added the following non-index predicates to our SQL!
如果我们将以下非索引谓词添加到我们的SQL将会怎样呢？
What kinds of predicates are used to join the referenced tables?
使用了哪些种类谓词来连接引用表？
For the predicates, use terms from the vocabularies in Table 2.
对于谓语，使用来自表2中的词汇表的术语。
Histograms are used to calculate the selectivity of the predicates.
直方图用于计算谓词的选择率。
Searching for a hash value with range predicates is straight-forward.
使用范围谓词搜索hash值很简单。
Table-level predicates typically exist on some dimension tables as well.
表级谓词通常也存在于一些维度表中。
Tip 9: Put document filtering predicates in XMLEXISTS instead of XMLQUERY
提示9：将文档过滤谓词放入 XMLEXISTS 中，而不是放入 XMLQUERY中
Statistical correlation of multiple local equality and local IN predicates.
多个本地等式和本地in谓词的统计关联。
These predicates can also be used in the WHERE clause of the SELECT statement.
这些谓词还可以用于select语句的where子句中。
At OPERATORS (8) and (7), you are not applying any local or join predicates.
在OPERATORS(8)和(7)上没有任何局部或连接断言。
应用推荐