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操作符都意味着在执行计划中有一个地方要将一个查询或请求转发到一个远程数据源。
For INSERT, UPDATE, and DELETE queries involving nicknames, in some cases (explained below), all the work might be done by the remote data source, and a SHIP operator will not be found in the FQEP.
对于使用了昵称的INSERT、UPDATE和DELETE查询,在某些情况下(后面会解释),所有工作可能都是由远程数据源来做,而在FQEP中没有ship操作符。
As before, each SHIP operator has a buffer associated with it.
和之前一样,每个SHIP操作符有一个相关联的缓冲区。
While the agents are busy doing steps 3 and 4 above, the union operator (run by the coordinator agent) starts reading data from the SHIP buffer on the first leg of the union.
当代理正在执行上述步骤3和步骤4时,UNION操作符(由协调代理程序运行)开始从UNION的第一个分支上的ship缓冲区中读取数据。
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操作符相关的细节中找到。
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操作符之上,因为这样会改变查询的语义。
The SHIP operator gets the data from the remote data source.
ship操作符从远程数据源获取数据。
In these cases, the SHIP operator will remain synchronous in order to maintain the semantics of the query.
在这些情况下,SHIP操作符将保持同步,以维持查询的语义。
The UNION operator consumes the data a row at a time from the SHIP buffer and flows the row upwards to the application through the RETURN operator.
UNION操作符每次使用SHIP缓冲区中的一行数据,并将这行数据通过RETURN 操作符上传到应用程序。
Recall that a SHIP operator containing a remote statement indicates a portion of the query that is to be processed remotely.
包含远程语句的SHIP操作符表明要远程处理查询中的一部分。
The main difference between RPD and SHIP is that the RPD operator does not contain an SQL statement.
RPD与SHIP之间主要的不同在于,RPD操作符不包含sql语句。
IT then reads from the outer table BAD_CREDIT using the SHIP operator, hashing the join column values, and checking in the lookup table generated for the inner table.
然后,它使用SHIP操作符读外表BAD_CREDIT,散列连接列的值,并检查为内表生成的查找表。
The remote query encapsulated by the leftmost SHIP operator is sent to the remote data source at which the US.Sales table resides.
由最左边的SHIP操作符封装的远程查询被转发到存放US. sales表的远程数据源上。
The UNION operator reads data from each SHIP buffer, one buffer at a time. The sequence of operations is as follows
而UNION操作符则从每个SHIP缓冲区中读取数据,每次读取一个缓冲区。
Here, the entire query is executed by the Oracle server, so you only see a RETURN operator without any SHIP operator.
在这里,整个查询都由Oracle服务器执行,所以只能看到一个return操作符,而看不到任何ship操作符。
Federated asynchrony can be recognized in execution plans by the existence of the new ATQ (Asynchronous Table Queue) operator directly above SHIP operators corresponding to remote operations.
通过对应于远程操作的SHIP操作符上的AT Q (asynchronousTableQueue)操作符,可以识别执行计划中的联邦异步。
The SHIP operator does not have a statement associated with it, as this SHIP operator stands for transferring data from the federated server to Oracle.
SHIP操作符没有相关联的语句,因为这个 SHIP 操作符表示将数据从联邦服务器传送到Oracle。
The Screen interface is designed to give the operator a full overview of the vessels status due to stability and strength margins, ship load and reserve capacity.
屏幕界面设计,使操作者的储备能力得到充分概述由于船只状况的稳定和实力的利润,船舶装载和。
The operator on ship can implement to pull through certain control method, to control orbit and posture of body, achieve and carry out different purposes of the underwater detection mission.
拖曳船上的操作者可以通过一定的控制方式实施对拖曳体的轨迹与姿态控制来达到执行不同水下探测任务的目的。
The identification of "ship operator" is one of the important issues, which cries for settlement in maritime judicial practice.
船舶经营人的识别问题是海事司法实践中迫切需要解决的重要问题之一。
If illegal modification is a great danger, the operator of the ship will also face great danger.
如果非法改装则是面临很大的危险,操作船舶的人员也会面临很大的危险。
Results 16 risk factors such as crews' nationalities, ship operator, epidemic prevalence region and month, ship age etc were selected to establish structural equation model.
结果筛选船员国籍、船舶经营者、来自疾病流行区、月份、船龄等16个危险因素,建立了结构方程模型。
Once the ship was mistakenly detained, the owner or the operator or the charterer will suffer losses from this deeds, including the owner of the cargo loaded.
一旦船舶被错误扣押,被扣押船舶的所有人或经营人或承租人,有时还包括船舶上所载货物的货主等,都会因此而遭受损失。
The shipowner designated in the foregoing article and Paragraph 1 of this article includes the owner, lessee, agent and operator of a ship.
前条及第一项所定船舶所有人,包括船舶所有权人、船舶承租人、经理人及营运人。
The shipowner designated in the foregoing article and Paragraph 1 of this article includes the owner, lessee, agent and operator of a ship.
前条及第一项所定船舶所有人,包括船舶所有权人、船舶承租人、经理人及营运人。
应用推荐