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.
现在检索列表需要一个快速、单个的查询。
Since there are no steps following the variable name, this query expression results in a single node which happens to be the current node.
由于在变量名后面没有任何步骤,因此该查询表达式将产生一个单一节点,即正好是当前的节点。
The DataReader class can incrementally load the results of the same query and present a single row at a time to an application.
datareader类可以递增地加载同一查询的结果,并且一次向应用程序提交单个行。
GWFASTA allows the submission of more than one sequence as a single query for a FASTA search.
GWFASTA允许超过一条序列作为一个单个查询提交进行FASTA搜索。
The algorithm combines the global analysis with the local analysis to extract the context information of the user's marked query from single document.
该算法将全局分析和局部分析结合起来从单文档中抽取用户选定查询的上下文信息。
Because both of these views are defined with a single SQL select statement on the underlying table, the query performance will not suffer.
因为这两个视图都是在下面的表格上使用单独的SQL选择语句进行定义,所以不会影响查询性能。
In this simple process, with only a single instance of a single task, you don't need any finer control over the query.
在此简单的流程中,仅使用单个任务的单个实例,不需要对查询进行更精确的控制。
A scalar subquery is an embedded query that returns a single row that contains a single column — essentially, a single value, which is known as a scalar.
标量子查询是一种嵌入式查询,返回包含单个列的单个行,本质上就是单个值,该值称为标量。
When I run this query, every single object - including all the Employees returned earlier - is sent back.
当运行这个查询时,每个单一对象—包括以前返回的所有Employee—都被返回了。
Named queries enable you to define a query in a single location. There are many benefits to named queries.
命名查询使您能够在单个位置定义一个查询。
This article introduced a methodology for tuning single queries, and used a sample query to explain each step of the methodology in detail.
本文介绍了调优单个查询的方法,并举例详细说明了此方法的每一步骤。
We can define multiple conditions in a single Query Filter definition by using Boolean expressions.
可以使用布尔表达式在单个QueryFilter定义中定义多个条件。
This document is intended to provide a single point of reference for techniques and product behaviours when dealing with the Dynamic Query Mode delivered with IBM Cognos 10.
本文档旨在为处理IBMCognos10交付的DynamicQueryMode时的技术和产品行为提供单点参考。
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查询检索整个数据库。
The next step is to create an instance of QueryExecution, a class that represents a single execution of a query.
下一步是创建QueryExecution的实例,这个类表示查询的一个执行。
Data is partitioned by node, so these queries can each be answered by a single partition, using an indexed range query.
数据根据节点分块,所以这些查询能分别在各自的数据块,通过一个索引过的范围查询得到结果。
Once you specify that a post "has many" comments and a comment "belongs to" a single post, the same query that retrieves the post for reading will retrieve the comments for that post.
在指定一个post “有多条”评论而一条评论 “属于” 一个 post 之后,检索 post的查询将检索该 post 的评论。
For this purpose, I'm using DB2 V9 to store and query XML data about business partners, which I'll maintain in a single partners table.
为此,我将使用DB 2v9来存储和查询关于业务伙伴的XML数据,将在一个partners表中维护该数据。
Then in Transformer, a query is created for each of the separate list reports or separate list queries within a single report.
那么在Transformer中,查询是为每一个清单报告或一个报告中的每一个清单查询而创建的。
This procedure returns a single result set that contains a SQL VARCHAR column (for the client's name) and an XML column (for the client's email). The query will be similar to the following.
该过程返回一个简单的结果集,其中包含一个SQLvarchar列(用于客户的姓名)和一个xml列(用于客户电子邮件)。
I know this can be done with a loop and multiple queries, but I was hoping for a single query.
我知道这可以用一个循环和多个查询,但我希望一个查询。
With this method a single query causes DB2 to generate several tasks, which are executed in parallel to access the data.
通过这种方法,一条查询可以使DB2生成多个任务,这些任务被并行地执行,以访问数据。
The problem is that EXPLAIN provides estimates for only a single execution of a given query.
但问题是,EXPLAIN提供的只是特定查询的一次执行的估计值。
Therefore, it might be worthwhile to restructure your spatial query to ensure just a single call to the constructor function using common table expressions.
因此,可能有必要使用公共表表达式重新构造空间查询,以确保只调用一次构造函数。
The original query against the UNION ALL view is now simplified to a query against one single nickname.
UNIONALL视图上的初始查询现在被简化为对一个昵称的查询。
A single query to the data store would return everything you need.
对数据存储的单一查询就可以返回您所需要的任何东西。
A single query to the data store would return everything you need.
对数据存储的单一查询就可以返回您所需要的任何东西。
应用推荐