In this example, the query returns the names of all authors in the document who have written more than three books.
在本示例中,查询返回了文档中已编写了多于三本书的所有作者的名字。
At a large retailer, adding a missing index to a small, 2,000-row table in an 8 TB warehouse reduced the elapsed time of a critical decision support query from three hours to two minutes.
在一家大型零售商的8TB数据仓库中,在一个2,000行的小表上添加一个索引之后,一个决策支持查询花费的时间从三小时一下降到了两分钟。
For example, consider a federated union query across three sources.
例如,考虑一个跨三个数据源的联邦联合查询。
Each of these views is kept in sync when an item is selected, so that the query can be analyzed in all three different ways.
当某项记录被选中时这些视图彼此之间会保持同步,以便通过全部三种不同的方式对该查询进行分析。
Our search form will include three fields for a customizable search: the query, the maximum number of results to return, and the number of entries to display per result page.
我们的搜索表单会包含这三个字段用于一个可定制的搜索:查询,返回结果的最大个数,结果页面中每页显示的个数。
Combining three or more dimensions in a query without fact data, can also cause large Cartesian joins.
在一个查询中不带事实数据连接三个或更多维度,也能产生大型笛卡尔连接。
As you can see, the above code combines three tokens to generate a complete SQL query.
就像你看到的,上面的代码用三段字串组成了一个完整的SQL查询语句。
The article then provides a detailed description of the staff query XML syntax for the three staff resolution plug-ins that are part of Business Process Choreographer.
然后对于属于业务流程编排组成部分的三个人员解析插件,本文将提供其人员查询XML语法的详细描述。
The first XML document application steps you through the visual query generator tool to perform both XML and relational queries that drive all three applications.
第一个XML文档应用程序演示使用可视化查询生成器工具执行XML查询和关系查询,这是所有这三个应用程序都要用到的。
In the above example, performance of the federated query could be improved by executing all three remote legs of the UNION at the same time.
在上面的例子中,可以通过同时执行union的所有三条分支来提高联邦查询的性能。
Seeing as it's inefficient to re-enter the same code three times, a looping mechanism can be employed to query the registries of each machine in turn.
我们注意到,三次重复输入相同的代码效率很低,因此可以使用循环机制来轮流查询每台机器的注册表。
JOLAP's query requirements and model facilitate the creation and execution of the three common types of OLAP query, namely: dimension queries, edge queries, and data queries.
JOLAP的查询需求和模型简化三种常见olap查询的创建和执行,即多维查询、边界查询和数据查询。
As you can see, the query was executed three times, and the average elapsed time is about 307 seconds, which is very slow.
如您所见,查询执行了三次,平均运行时间大约是307秒,非常慢。
Three or more tables are involved. A polymorphic query generates SQL like
涉及三张或更多的表,多态查询生成的SQL是这样的
Using the sample model in this document, adding items in Query Studio from all three dimensions returns a much reduced record set.
在本文的模型示例中,从所有三个维度向QueryStudio添加项目,然后返回一个缩减了很多的数据集。
This query returns a sequence of three XML elements when run against the sample data.
对于示例数据,这个查询返回由三个XML元素组成的一个序列。
Intuitively, an access path is a procedural description of query execution that consists of three components.
直观地说,访问路径是查询执行的程序说明,其包括三个组件。
As you learned in the previous section, executing a database query involves three main concepts.
如上一部分所述,执行数据库查询包括三个主要概念。
A SELECT query whose graph pattern included foaf: depiction would only find three solutions.
在foaf:depiction中包含的图形模式的SELECT查询可能只会发现三个结果。
In addition to fetching data out of cursors, you can load values from a single row query into variables using three different techniques.
除了从游标获得数据之外,可以使用三种不同的技术将来自单行查询的值装载进变量中。
One possible MQT definition that will satisfy the three variations of the query above looks like.
满足以上三个查询变体的一个可能的MQT定义类似于。
There are three kinds of charts that are supported by advanced query statistics (reference Figure 2)
高级查询统计支持三种图表(参考图2)
The Inquiry APIs lend themselves to three query patterns.
查询api把自身归为三种查询模式。
There are three types of work items used to store the three types of staff query results.
有三种类型的工作项用来存储三种类型的人员查询结果。
In the XQuery business logic, three fields are used to search books, and six query strategies need to be constructed in considering the cases.
在XQuery业务逻辑中,使用三个字段搜索图书,需要建立六种查询策略。
To execute XML queries, DB2 9 introduces three new internal query operators called XSCAN, XISCAN, and XANDOR.
为了执行XML查询,DB 29引入了三个新的内部查询操作符,名为XSCAN、XISCAN和XANDOR。
When you run the query in Listing 3, the database reports three Brians, two of them Brian Goetz. a similar effect would occur if the persons.data.
当运行清单3中的查询时,数据库将报告三个Brian,其中两个是Brian Goetz。
Change the query to DOM hierarchy, and you'll see how only the first three entries of DOM are highlighted, as shown in Figure 1.
将查询更改为DOMhierarchy,您将看到如何只高亮显示前三个DOM条目,如图1所示。
Uses these three parameters to call the named query SLAEndpointLookup.
使用这3个参数来调用已命名查询SLAEndpointLookup。
In Figure 2, you see three different execution plans for this query (simplified output from db2exfmt).
在图2中可以看到该查询的不同执行计划(简化了db 2 exfmt的输出)。
应用推荐