Some report executions require executing sub-queries.
一些报表执行需要执行子查询。
What are the Properties and Different Types of Sub-Queries?
子查询的属性是什么,有哪些不同类型的子查询?
The second and subsequent arguments are strings, which are treated as sub-queries.
第二个和后续的参数为字符串,它们被当作子查询。
IWA does not handle all types of queries yet, such as correlated sub-queries or queries using temp tables.
IWA还无法处理所有类型的查询,比如关联子查询或使用临时表的查询。
They can be simple, UNION, or joined sub-queries, including OUTER joins, and can include the ORDER BY clause.
它们可以是简单子查询、UNION或连接(包括OUTER 连接)子查询,并且可以包括ORDERBY 子句。
Drill into parts of the query in more detail, such as referenced views and sub-queries, by expanding and collapsing sections of a complex SQL.
通过扩展和收缩复杂SQL的一部分,来深入获取更详细的查询部分,例如引用视图和子查询。
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关系模型,并通过向远程数据源发送子查询以帮助联邦引擎实现查询处理。
Some implementations of the data federation pattern are capable of sending some or all of the sub-operations (sub-queries) in parallel to the integrated source systems.
数据联合模式的有些实现可以将部分或全部子操作(子查询)以并行方式发送到集成源系统。
These sub queries are called derived tables or table expressions.
这些子查询被称作派生表或表表达式。
If more complex queries are executed, or if several queries are executed in sequence, the difference in the execution time is not just sub-seconds but seconds or even minutes.
如果要执行更复杂的查询,或者要连续执行多个查询,那么执行时间的差距就不是次秒级的,而是以秒甚至分钟来计算的。
There is also a full outer join between these two sub queries based on a column called sc.
在基于名为sc 的列上还有两个子查询的完全外连接。
Correlation names for sub queries are allowed.
允许子查询中使用相关名称(correlation name)。
This allows the data federation server to receive queries against the integrated view and to calculate the optimum number and types of sub operations to perform.
这就允许数据联合服务器接收对集成视图的查询和计算要执行的最优子操作数量和类型。
These queries always require sub-document level access to evaluate predicates and to extract document fragments.
这些查询通常需要子文档级访问来运算谓词和提取文档片段。
The statement contains a cyclic reference to one or more sub queries.
此声明包含一个对一个或多个子查询的循环引用。
Depending upon the load placed on the server and the relative size of the entity bean that has been requested, queries on entity beans can have sub-par response times.
根据服务器上的负载和所请求实体bean的相对大小,实体bean的查询可能有不达标的响应时间。
Depending upon the load placed on the server and the relative size of the entity bean that has been requested, queries on entity beans can have sub-par response times.
根据服务器上的负载和所请求实体bean的相对大小,实体bean的查询可能有不达标的响应时间。
应用推荐