The standard query operator methods that perform selection are listed in the following section.
下面一节中列出了执行选择的标准查询运算符方法。
The standard query operator methods that perform generation are listed in the following section.
下节会列出执行产生的标准查询运算子方法。
The standard query operator methods that partition sequences are listed in the following section.
下面一节中列出了分区序列的标准查询运算符方法。
The standard query operator methods that group data elements are listed in the following section.
下节会列出将资料项目分组的标准查询运算子方法。
The standard query operator methods that perform quantifier operations are listed in the following section.
以下部分列出了执行限定符运算的标准查询运算符方法。
The standard query operator methods that perform aggregation operations are listed in the following section.
以下部分列出了执行聚合运算的标准查询运算符方法。
If you use a query operator that materializes its source before yielding the first item, you will not retain a small memory footprint.
如果您使用的查询运算符在生成第一项之前具体化其源,则您不会保持很少的内存需求量。
Therefore, each operator in an XML query language must be well defined for all these possible inputs.
因此,应为所有这些可能的输入很好地定义XML查询语言中的每个运算符。
Check each query filter, including its field name, operator, and filter value.
检查每一个查询筛选,包括它的字段名,操作者以及筛选值。
With asynchrony, all SHIPs with an ATQ operator directly above them would start at the same time as the main query starts.
如果有异步,那么当主查询开始时,所有在它们的上一层有at Q操作符的SHIP也随之开始。
Recall that each SHIP operator indicates a point in the execution plan at which a query or request is sent to a remote data source.
还记得吗,每个ship操作符都意味着在执行计划中有一个地方要将一个查询或请求转发到一个远程数据源。
The remaining two sections provide details on each operator of the access plan, and the tables and/or indexes used by the query.
其余的两个区域提供了关于访问计划的每个操作符以及查询所使用的表和/或索引的细节。
Note: the query optimizer considers using a functional index when the index expression is used in a relational expression or as an argument to one of the operator class functions.
注意:当索引表达式被用于关系表达式,或作为某个操作符类函数的参数时,查询优化器将考虑使用函数索引。
Check to see if each remote operator contains the maximum portion of the query that can theoretically be evaluated by a given data source.
检查每个远程操作符是否包含在理论上可由给定数据源计算的查询中的最大部分。
To use a table subquery, you need to use an SQL operator to combine the embedded query with a Boolean expression.
要使用表子查询,需要使用SQL操作符将嵌入式查询与布尔表达式组合在一起。
To get all subordinates over all levels, the PRIOR operator must be added to the CONNECT BY part of the hierarchical query clause.
要获取所有级别上的所有下属,必须将PRIOR运算符添加到分级查询子句的CONNECTBY部分。
An operator class is used in conjunction with the access method to specify the operators used for building the index and during query optimization.
将操作符类与访问方法结合使用,可以指定创建索引和优化查询时使用的操作符。
For our purposes, it suffices to understand that asynchrony is introduced into a federated query plan by the optimizer's judicious placement of the TQ (Table Queue) operator.
就我们此处的目的而言,只要理解异步是通过优化器明智地放置TQ(表队列)操作符而引入到联邦查询计划之中的就足够了。
A query that USES the common dimensions is executed in parallel for each of the composing cubes, and the results are aggregated according to the virtual cube merge operator.
使用相同维度的查询将同时在每个子数据集中执行,得到的结果根据虚拟数据集的合并运算符进行合并。
When a query is issued against a virtual cube, that query is routed to the depending cubes, which produces two intermediary results that are aggregated according to the virtual cube's merge operator.
当对某个虚拟数据集执行查询时,查询将被发送到子数据集,子数据集将生成两个中间结果,这两个结果又将根据虚拟数据集的合并运算符进行合并。
If you run the final query from Listing 6, as it is shown above, you should see in the access plan that DB2 decides to use the extended index by the EISCAN operator.
如果运行清单6中最后的查询(如上面所示),这么在访问计划中应该可以看到,DB 2决定通过EISCAN操作符使用扩展的索引。
For SELECT queries, the text of the remote SQL statement can be found in the details associated with the SHIP operator in the query execution plan.
对于SELECT查询,远程sql语句中的文本可以在查询执行计划中与SHIP操作符相关的细节中找到。
The return operator completes the query execution and returns the query result to the API.
RETURN操作符将完成查询执行,并将查型结果返回到API。
Under certain circumstances,it is not possible for the optimizer to place an ATQ above a SHIP operator because doing so changes the semantics of the query.
在某些环境下,优化器不能将一个ATQ 放在一个SHIP操作符之上,因为这样会改变查询的语义。
Comparing the access plans in Figure 4 and Figure 5 shows again with the EISCAN operator that an extended index is used by the query.
比较图4和图5中的访问计划,会发现对于EISCAN操作符,查询使用了一个扩展索引。
In these cases, the SHIP operator will remain synchronous in order to maintain the semantics of the query.
在这些情况下,SHIP操作符将保持同步,以维持查询的语义。
Recall that a SHIP operator containing a remote statement indicates a portion of the query that is to be processed remotely.
包含远程语句的SHIP操作符表明要远程处理查询中的一部分。
To mark a row within the query elements table as a column definition, the Operator choice for the row must be either asc for ascending or desc for descending.
要在查询元素表中将行标记为列定义,行的Operator选择对升序必须为asc,对降序必须为DESC。
To find out all accounts with privileges, you can query each of the system catalog views and combine the results together using the UNION operator, as shown in Listing 4.
要查明具有特权的所有帐号,可以查询每个系统编目视图并使用UNION操作符将结果组合在一起,如清单4所示。
Here, the entire query is executed by the Oracle server, so you only see a RETURN operator without any SHIP operator.
在这里,整个查询都由Oracle服务器执行,所以只能看到一个return操作符,而看不到任何ship操作符。
应用推荐