Select a record from the results of this query.
从这个查询的结果中选择一个记录。
Most aspects of this query should be familiar to you by now, so concentrate on the conditional logic.
现在您应该对这个查询的大部分感到熟悉,所以我们只关注条件逻辑。
This query USES square brackets, so what's wrong with it?
这个查询使用了方括号,那么它错在哪里呢?
She can execute directly from this query, or she can return to the tree view and run her tests from there.
她能够从这个查询中直接执行,也可以返回到属性图表中从那里运行她的测试。
The first run of this query takes 179 ms, but the next run takes only 15 ms.
第一次运行该查询耗时179毫秒,但下一次运行则只耗费了15毫秒的时间。
This query plan shows an index scan using our functional index.
该查询计划显示索引扫描使用了函数索引。
This query plan shows full table scans.
该查询计划显示了全表扫描。
This query plan shows the use of a functional index.
该查询计划展示了函数索引的使用。
This query instructs DB2 to retrieve the element of contacts for various companies.
这个查询指示DB2检索不同公司联系方式的元素。
Figure 11 shows a FQEP for this query where one remote statement is sent to each warehouse server.
图11展示了这个查询的一个FQEP,其中一个远程语句被发送到每个仓库服务器。
Execution of this query evaluates the predicate to find all instances that match the template instance.
执行该查询将计算谓词以查找所有与模板实例匹配的实例。
Listing 3 shows the result of this query run against the data in Listing 1.
清单3展示了针对清单1中数据运行该查询时得到的结果。
We can then examine the equivalent symbolic tree representation of this query plan in Figure 1.
随后,我们可以查看图1,其中展示了这个查询计划的等效符号树表示形式。
You may wonder why a WHERE clause appears in this query.
您可能想知道,为什么这个查询中出现了一个WHERE 子句。
Listing 7 shows the section in the Dynamic SQL snapshot output for this query.
清单7展示了动态sql快照输出中针对该查询的那部分。
Since this query is a cursor, DB2 is facing a dilemma.
因为这个查询是一个游标,因此DB 2正面临一个窘境。
Figure 3 illustrates the workings of this query.
图3演示了该查询是如何工作的。
This query will return only 200 rows.
该查询将只返回200行。
Listing 3 illustrates this query in practice.
清单3实际演示了此查询。
Figure 13 illustrates the output of this query.
图13显示了此查询的输出。
This query will return a set of XML elements and values.
这个查询将返回一组xml元素和值。
Other users that would have qualified for this query will be ignored.
符合该查询条件的其他用户将被忽略。
Running this query should return the XML document shown in Listing 4.
运行该查询将返回清单4所示的XML文档。
The result from this query is an XML representation of your data.
这个查询生成的结果是数据的XML表示。
Figure 11 demonstrates that the index has indeed been beneficial for the execution of this query.
图11显示这个索引确实对这个查询的执行有好处。
Two aspects of this query are worth noting.
该查询有两个方面值得注意。
Listing 11 shows the XML output from running this query.
清单11展示了运行该查询产生的XML输出。
This query can take hours to run on big servers with expensive storage systems.
在配备昂贵存储系统的大型服务器上运行此项查询需要花费几个小时的时间。
In this query, the customer information is taken from the CUSTOMERS table at the federated server.
在这个查询中,客户信息来自联邦服务器上的customers表。
The threshold attribute of the element is ignored by this query.
此查询将忽略元素的阈值属性。
应用推荐