The second predicate is applied only when the row is disqualified by the first predicate.
仅当第一个谓词认为行不合格时第二个谓词才应用。
In addition to proper index or predicate containment with wildcards and namespaces, the second requirement for index eligibility is that data types of predicates and indexes need to match.
除了索引或谓词与通配符和名称空间的包容性之外，索引合格性的第二个要求是谓词和索引的数据类型必须匹配。
The second query uses an XML predicate to ensure that only the rows for "95141" get generated, resulting in a shorter runtime, especially on a large data set.
第二个查询使用一个 XML 谓词来确保只生成对应于 “95141” 的行，从而减少了运行时间，对于大型的数据集，这种方法带来的性能好处尤其显著。
应用推荐