The Senate's IT group moved from single-query fixes to ongoing “preventive” optimization and tuning.
参议院的IT团队从单一查询修复转变为了持续的 “预防性”优化和调优。
This article will focus on single-query tuning; the next article of this series will extend the methodology in this article to introduce the workload tuning in detail.
本文着重介绍单个查询调优；本系列的下一篇文章将会扩展本文中的技术，详细介绍负载调优。
Now retrieving the list requires a fast, single query.
现在检索列表需要一个快速、单个的查询。
Otherwise, a single query could cascade to loading the entire database.
否则，一个简单的查询就能级联地加载整个数据库。
With this method a single query causes DB2 to generate several tasks, which are executed in parallel to access the data.
通过这种方法，一条查询可以使DB2生成多个任务，这些任务被并行地执行，以访问数据。
The default allows a maximum of one SHIP/RPD for any data source within a single query to be asynchronous.
这个缺省值允许一个查询中的任何数据源最多只有一个SHIP/RPD为异步的。
Of course, not many of us would need (or want, for that matter) to retrieve the entire database with a single HQL query.
当然，我们之中没有多少人需要只用一个HQL查询检索整个数据库。
However looking at the total number of possible flights to ones that are viable and preferable should start to eliminate the need to apply Brute Force searching to every single query.
然而，看看可行的、首选的航班数量如此之多时，我们应该认识到不要再用穷举搜索法对每一次查询进行验证。
The problem is that EXPLAIN provides estimates for only a single execution of a given query.
但问题是，EXPLAIN提供的只是特定查询的一次执行的估计值。
The original query against the UNION ALL view is now simplified to a query against one single nickname.
UNIONALL视图上的初始查询现在被简化为对一个昵称的查询。
This could have been avoided by loading both the Person and the Address component in a single query because we knew that our business use case required both components.
解决办法就是在一个单独的查询中将Person和Address都得到，因为我们知道这两个组件都是业务流程所需的。
Start by changing the single query to two queries, with the outside query looping through each user see Listing 6.
首先将单个的查询变为两个查询，用outside查询在每个用户间进行循环。
When I run this query, every single object - including all the Employees returned earlier - is sent back.
当运行这个查询时，每个单一对象—包括以前返回的所有Employee—都被返回了。
In addition to being able to use XQuery to search relational data and SQL to search XML data, users can issue a single query to search both relational data and XML data at the same time.
除了使用XQuery搜索XML数据和使用SQL搜索关系数据外，用户还可以在同一个查询中同时搜索关系数据和XML数据。
We can define multiple conditions in a single Query Filter definition by using Boolean expressions.
可以使用布尔表达式在单个QueryFilter定义中定义多个条件。
Combined queries should only apply if your connector can execute the combined query as a single operation.
只有在连接器能够将组合查询作为单一操作执行时，才应该应用组合查询。
For some queries, the wanted result cannot be retrieved with a single LDAP query.
对于某些查询，无法使用单个ldap查询来检索所需的结果。
Query Language (YQL) as a single endpoint JSONP service that lets you query, filter, and combine data from different data sources.
查询语言(YQL)，这种单端点的JSONP服务允许您查询、过滤和合并来自不同数据源的数据。
A single query to the data store would return everything you need.
对数据存储的单一查询就可以返回您所需要的任何东西。
In the case of a query, a single object or a collection of objects is returned.
在执行查询的情况下，返回单个对象或一个对象集。
Furthermore, they can write a single query that searches and integrates both forms of data.
而且，可以编写一个查询同时搜索和处理这两种数据形式。
The following parameters can be used to control the maximum number of ATQs that the asynchrony algorithm will place within a single query.
下面的参数可用于控制异步算法可以放入到单个查询中的ATQ的最大数量。
Multiple slices of data can be returned in a single query by using grouping sets or super-groups (such as ROLLUP) in the GROUP-BY clause of the SQL statement.
通过在sql语句的GROUP BY子句中使用多个分组集或超级组(比如rollup)，可以在一个查询中返回数据的多个切片。
The pros include a single table, simple query and easy association with other tables.
这样做的优点包括只有一张表、查询简单以及容易与其他表进行关联。
This server option specifies the maximum number of concurrent requests that can be simultaneously active on behalf of a single federated query to the given data source.
该服务器选项指定可代表一个联邦查询向特定数据源同时激活的并发请求的最大数量。
Result: the SQL query fetches a single row that is present in the front end.
结果：SQL查询获取到出现在前端的一个行。
In addition to fetching data out of cursors, you can load values from a single row query into variables using three different techniques.
除了从游标获得数据之外，可以使用三种不同的技术将来自单行查询的值装载进变量中。
In this case, SharePoint only needs to query a single record from the Lists table in the content database.
在这种情况下，SharePoint只用在内容数据库中查询Lists数据表的单个记录。
Storing multiple table or index fragments in a single dbspace improves query performance over storing each fragmented expression in a different dbspace.
与在单个dbspace中保存多个表或索引片段提高了查询性能，这样做胜过将每个分段表达式存储在不同的dbspace中。
Indeed, applications can freely employ statements from both query languages, and a single query statement can actually incorporate both SQL and XQuery.
实际上，应用程序可以自由地使用这两种语言的语句，而且一个查询语句可以结合使用SQL和XQuery。
应用推荐