How to: Group Rows in Query Results.
如何:将查询结果中的行分组。
Certain heuristics can be applied in query rewrite.
在重写查询时,可以应用某些试探法。
Like the processes, the queries are organized in query groups.
与过程类似,查询是在查询组中组织的。
As stated above, performance is the major concern in query tuning.
如上所述,性能是查询调优中主要关心的问题。
Specify the information that will be displayed in query views.
指定将在查询视图中显示的信息。
Now consider the contents of the package as they appear in Query Studio.
现在考虑一下QueryStudio中出现的包的内容。
Index idx6 is also the only index that matches the predicate in query 6.
索引idx6还是与查询6中的谓词相匹配的惟一索引。
This asynchrony can lead to significant improvements in query performance.
这种异步可以显著提高查询的性能。
Hence, the need for statistical views arises in query plan optimization.
因此,在进行查询计划优化时,就需要使用统计视图。
Query Parse Error - try rebuilding in Query Wizard or by using View Designer Join Tab.
查询解析错误-请试着在“查询向导”中或通过用“视图设计器”的“联接”选项卡重建。
Aggregation is one of the most important operations in query processing for sensor networks.
聚集运算是传感器网络查询处理中最重要的一个运算。
Responding to the trait of URMS, we design a XML stream querying algorithm in query groupware.
针对URMS的特点,在其查询组件中设计了一种基于流的XML查询算法。
An index scan is typically shown in Query Tuner as a group of four nodes in the access path graph.
在访问路径图中,一个索引扫描通常作为一组四个节点显示在QueryTuner上。
These properties appear in the properties window when you have a query open in query and View Designer.
当您在查询和视图设计器中打开查询时,这些属性将出现在“属性”窗口中。
Initializers are typically used in query expressions when they project the source data into a new data type.
初始设定式通常会用在将来源资料规划为新资料型别的查询运算式中。
In Query 12, we pass every dept and project document into the XQuery inside XMLEXISTS and express the join condition there.
在查询11中,我们将每一个dept和project文档放入XMLEXISTS中传递给XQuery,并在那里表示连接条件。
Using the sample model in this document, adding items in Query Studio from all three dimensions returns a much reduced record set.
在本文的模型示例中,从所有三个维度向QueryStudio添加项目,然后返回一个缩减了很多的数据集。
Implicitly-typed arrays are usually used in query expressions together with anonymous types and object and collection initializers.
隐含型别阵列通常是在查询运算式中与匿名型别及物件和集合初始设定式一起使用。
This helps, but of course adds spikes in query response times whenever the indexes are rebuilt which I would like to avoid or minimize.
这有助于,当然增加了查询响应时间的尖峰,每当重建索引,我想避免或减少。
OQL queries can also invoke methods on the objects themselves, use regular expressions as part of the query, and use built-in query tools.
OQL查询同样可以调用对象的方法,将正则表达式作为查询的一部分,并使用内置查询工具。
The research on query processing is the key to query optimization, and one of the most important things in query processing is logical optimization.
对查询处理过程的研究是实现查询优化的关键,而查询处理过程中最重要的是逻辑优化阶段。
However, prior to DB2 9.7 the "direction" of the XMLEXISTS predicate in Query 1 and Query 2 determines which of the two execution plans in Table 5 is used.
不过,在DB 2 9.7之前,查询1和查询2中的XMLEXISTS的方向决定了使用表5中的哪个执行计划。
Optimization guidelines and statistical views are useful features to compensate the access plan evaluations when exceptions in query performance occur.
当查询性能中出现例外情况时,优化指南和统计视图特性对于弥补访问计划估计的不准确性非常有用。
It provides a DB2 relational model for the remote data and assists the federated engine in query processing by sending sub-queries to the remote data source.
它提供了远程数据的DB 2关系模型,并通过向远程数据源发送子查询以帮助联邦引擎实现查询处理。
As you'll see later, the exception is that the Google data API does support setting ranges of start dates to limit which events are included in query results.
正如您稍后将看到的,例外情况是Google数据API支持设置开始日期范围以限制查询结果中包括的事件。
Changes in query activity over time, including the number of queries, number of users, average response times, and the worst response time within a timeframe.
查询活动随时间的变化,包括查询数量、用户数量、平均响应时间以及某一时间段内最差响应时间。
To assess the difference in query performance between XML and CLOB columns, five queries were designed to cover the following common search and retrieval cases.
为了评估XML和clob列之间的查询性能差异,本文设计了5个查询来涵盖以下常见的搜索和检索情况。
In addition, it depends on a proper choice of how to group containers to ensure that containers belonging to the same group also appear together in query predicates.
此外,它通过正确选择将容器进行分组的方法,确保属于同一个组的容器也会在查询谓语中一起出现。
In addition, it depends on a proper choice of how to group containers to ensure that containers belonging to the same group also appear together in query predicates.
此外,它通过正确选择将容器进行分组的方法,确保属于同一个组的容器也会在查询谓语中一起出现。
应用推荐