The cardinality represents the estimated number of rows returned from the access plan operator.
基数(cardinality)表示访问计划操作符所返回的行的估计数目。
The access plan operator is either an action that must be performed on data, or the output from a table or an index.
访问计划操作符要么是必须在数据上执行的动作,要么是表或索引的输出。
At each operator in the access plan, the optimizer estimates the cardinality output from the operator.
对于访问计划的每个操作符,优化器将估计该操作符的基数输出。
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.
其余的两个区域提供了关于访问计划的每个操作符以及查询所使用的表和/或索引的细节。
The remote access plan contained in the RPD operator is constructed by the wrapper and contains the necessary specification to invoke the remote request from the non-relational data source.
RPD操作符中的远程访问计划是由包装器构造的,其中包含为调用来自非关系数据源的远程请求所需的规范。
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 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(表队列)操作符而引入到联邦查询计划之中的就足够了。
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操作符相关的细节中找到。
It's best to read such execution plans from the left-lowest operator in the tree, since the logical flow in the plan is from bottom to top and left to right.
因为执行计划中的逻辑流是自下而上、从左到右,所以看此类执行计划时,最好是从树中左下方的操作符开始。
An IXAND plan with all applicable relational and XML indexes appearing under the IXAND operator.
一个IXAND计划,其中所有合适的关系和xml索引出现在IXAND操作符下。
The db2exfmt output for an index ORing plan shows a RIDSCN operator with two or more XISCAN operators as input.
索引oring计划的db 2 exfmt输出显示了一个ridscn操作符,其中以两个或更多个XISCAN操作符作为输入。
A XANDOR plan with all applicable XML indexes appearing under the XANDOR operator.
一个XAND OR计划,其中所有合适的xml索引出现在XANDOR操作符下。
The earlier access plan shows that the total cost of the SELECT statement is 3420.41 timerons, which is from the table scan operator (TBSCAN) against the ACCOUNT table.
前面的访问计划显示select语句的总成本是3420.41timerons,这来自于表扫描操作符(TBSCAN)对ACCOUN t表进行的操作。
Go to this specific operator ID in the detailed operator section of the access plan, and isolate the predicates applied at the operator (in this case, IXSCAN). For example.
在访问计划的详细操作部分找到这个操作id,并隔离应用于该操作(即ixscan)的断言。
At runtime, any operator below an ATQ in a plan is executed by a separate db2agent, known as a subagent (implemented either as a process or a thread depending on the operating system).
在运行时,执行计划中at Q之下的任何操作符都是由一个单独的db2agent执行的,这个单独的db2agent被称作子代理(被实现为一个进程或一个线程,这取决于操作系统)。
If specified, it requests an access plan using an XISCAN operator over this particular XML index.
如果指定了索引名的话,它将对特定的xml索引使用XISCAN操作符来请求一个访问计划。
The plan shows a table scan over the aggregate_sales MQT. Moreover, the details of the operator table scan shows the following details.
该计划展示了aggregate_salesMQT上的一个表扫描。
It is a more important problem to plan coverage on high-speed mobile environment for operator.
如何解决高速移动环境下的网络覆盖是运营商非常重视的问题。
Has the vessel Operator submitted a vessel Spill Response Plan to the US Coast Guard, which has been approved by official USCG letter?
船舶经营人是否向美国海岸警备队递交了船上油污应急计划,该计划之前已经被警备队正式批准。
Through the action to analysis and improve to compare with the operator and equipment, and responsible for the production line reasonable worker plan.
通过动作分析进行设备人机化比的测定与改善驱动,负责产线人员计划分析的;
Through the action to analysis and improve to compare with the operator and equipment, and responsible for the production line reasonable worker plan.
通过动作分析进行设备人机化比的测定与改善驱动,负责产线人员计划分析的;
应用推荐