Change the WHERE predicate to o.author.name
将WHERE 的谓词改为 o.author.name = ?
Query 2 applies the join predicate to the authors table.
查询2对authors表应用连接谓词。
This will allow the predicate to be applied to the index.
这使谓词可以用于索引。
A guideline to disable the transformation of the in predicate to a join.
一个原则是禁用in谓词到连接谓词的转换。
The following query explicitly casts both sides of the join predicate to DOUBLE.
以下查询明确地将连接谓词的两端转换为DOUBLE。
You pass a formula used as a predicate to see if it is a valid rule for the element.
您传递一个用作谓词的公式,检查它是否是一个有效的元素规则。
Performance can be improved by allowing the predicate to be applied close to the table access.
通过允许将谓词应用到表访问,可以提高性能。
Execution of this query evaluates the predicate to find all instances that match the template instance.
执行该查询将计算谓词以查找所有与模板实例匹配的实例。
Then supposed you want the first CD; you can use a predicate to get that CD, like this: /cds/cd[1].
假设需要第一张唱片,可以使用谓词来实现:/cds/cd[1]。
Enter an XPath query, using the matches predicate to exploit the full-text search capability, and click ok.
输入一个XPath查询,并使用匹配谓词来利用全文搜索功能,然后单击ok。
Full-text searches use the CONTAINS predicate to locate rows that have specified text in a given column.
全文搜索使用CONTAINS谓词来查找在给定列中包含指定文本的行。
To do so, modify the previous query by adding another predicate to the WHERE clause to test for missing email information.
为此可以修改之前的查询,添加另一个谓词到WHERE中,以测试是否缺少email信息。
While Update 26 USES an SQL predicate to select the document, Update 27 USES an XQuery predicate and avoids the use of SQL completely.
更新26使用SQ l谓词选择文档,而更新27使用XQuery谓词,完全避免使用SQL。
A view could use the value of this global variable in a predicate to select only those rows for which the user's department is assigned.
视图可以在谓词中使用该全局变量的值,从而只选择分配给用户所在部门的行。
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” 的行,从而减少了运行时间,对于大型的数据集,这种方法带来的性能好处尤其显著。
Now, if I may continue, once the CompareOther function has been written, the faithful needs only to write a binary predicate to wrap the comparison function.
既然这样,一旦CompareOther写好了,只需要写一个二元谓词将比较函数包装起来就可以了。
When an in predicate (or an equivalent or predicate) is used, the optimizer considers an IN-to-JOIN transformation, converting the in predicate to a join predicate.
当使用了一个in谓词(或一个等价的or谓词)时,优化器将会考虑使用一个in到join的变换,将一个in谓词转换成一个连接谓词。
This script aggregates the timing data from the start probe to the done probe, using a predicate to identify whether the calculation was ultimately for a prime or non-prime number.
这个脚本使用谓词区分最终结果为素数和非素数的计算,把从start探测到done探测的时间数据累加起来。
Since this query contains no value predicate to restrict either the books or the authors table, DB2 has to perform a table scan on either of the two tables to read all author IDs.
由于该查询没有包含用来限制books或authors表的值谓词,因此DB 2必须在两个表上执行表扫描,以便读取所有author ID。
The SBA has always expressed scepticism concerning the addition of tax crimes to the list of predicate offences.
SBA一直对将税务犯罪列入原发犯罪清单表示怀疑。
For example, you might select a node and then drill down to add a predicate.
例如,您可以选择一个节点,然后钻取到查询中添加一个谓词。
Within that predicate, you might drill down again to add another predicate.
在那个谓词中,还可以再次向下钻取,以添加另一个谓词。
This suggests a much better predicate selectivity than it appears to be!
这表明谓词选择性比其表现出来的还要好!
After pushing down the predicate, the statement looks similar to Figure 9.
下推谓词之后,语句看上去如图9所示。
Missing statistics can cause the optimizer to overestimate or to underestimate the selectivity of a predicate, and eventually to select an inefficient access path.
丢失的统计数据会让优化器高估或低估谓词的选择性,最终会选择低效的访问路径。
A predicate must be applied to a node set, but it can be applied to any node set.
谓词必须作用于节点集,但是可作用于任何节点集。
By default, an LDAP property will be assigned to a predicate that has a literal resource.
ldap属性默认分配文字资源谓词。
This is because, for a given row, the XMLEXISTS predicate evaluates to false only if the XQuery expression inside returns the empty sequence.
这是因为,对于一个给定的行,只有当里面的XQuery表达式返回空序列时,XMLEXISTS谓词才为false。
The user-defined predicate is associated to the function equalString, as shown in italics in Listing 5.
用户定义谓词被关联到函数equalString,如清单 5中的斜体 部分所示。
They use the SQL/XML predicate XMLEXISTS to select XML documents based on one or multiple conditions which are expressed in XQuery notation.
它们使用SQL/XML谓词XMLEXISTS根据一个或多个条件选择 XML文档,条件用XQuery表示法表示。
应用推荐