Two aspects of this query are worth noting.
该查询有两个方面值得注意。
Listing 3 illustrates this query in practice.
清单3实际演示了此查询。
A few aspects of this query are worth noting.
该查询的有些方面值得注意。
Select a record from the results of this query.
从这个查询的结果中选择一个记录。
Figure 13 illustrates the output of this query.
图13显示了此查询的输出。
Figure 3 illustrates the workings of this query.
图3演示了该查询是如何工作的。
Listing 3 shows this query and how it can be used.
清单3显示该查询以及使用方法。
DB2 returns a three-row result set for this query.
对于这个查询,DB2返回一个由三行组成的结果集。
It is noteworthy to look at the output of this query.
这里有必要看一下这个查询的输出。
You may wonder why a WHERE clause appears in this query.
您可能想知道,为什么这个查询中出现了一个WHERE 子句。
Listing 11 shows the XML output from running this query.
清单11展示了运行该查询产生的XML输出。
Figure 12 illustrates what the output of this query looks like.
图12显示了此查询的输出。
The threshold attribute of the element is ignored by this query.
此查询将忽略元素的阈值属性。
The result from this query is an XML representation of your data.
这个查询生成的结果是数据的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文档。
However, this query returns only one XML document from the sample table.
然而,这个查询只返回示例表中的一个XML文档。
Secondly, returning many empty rows makes this query needlessly slow.
其次,返回很多空行使查询速度不必要地慢了下来。
To perform this query in MongoDB, you would use the command in Listing 20.
要在MongoDB中执行此查询,需要使用清单20中的命令。
Listing 3 shows the result of this query run against the data in Listing 1.
清单3展示了针对清单1中数据运行该查询时得到的结果。
The first run of this query takes 179 ms, but the next run takes only 15 ms.
第一次运行该查询耗时179毫秒,但下一次运行则只耗费了15毫秒的时间。
Listing 7 shows the section in the Dynamic SQL snapshot output for this query.
清单7展示了动态sql快照输出中针对该查询的那部分。
These will be the only two attributes returned from the database by this query.
该查询只从数据库中返回这两个属性。
The attributes of the SYBSTOCKQUOTE procedure can be looked up using this query.
可以使用以下查询查找sybstockquote过程的属性。
These two query restrictions are combined in this query by using the Boolean AND operator.
可以通过使用Boolean AND操作符将这两个查询限制组合在该查询中。
The parameter information of the SYBSTOCKQUOTE procedure can be looked up using this query.
可以使用以下查询查找sybstockquote过程的参数信息。
The leftmost plan (a) is used if there is no eligible index for the predicates in this query.
如果该查询中没有合适的索引用于谓词,则使用最左边的计划(a)。
A better way to improve the performance of this query is to create a functional index on name.
改善查询性能的一种更好的方法是对name创建函数索引。
For Oracle procedures in a package, use this query in passthru mode against the Oracle server.
对于包中的Oracle过程,按passthru模式对Oracle服务器使用以下查询。
We can then examine the equivalent symbolic tree representation of this query plan in Figure 1.
随后,我们可以查看图1,其中展示了这个查询计划的等效符号树表示形式。
应用推荐