SHIP (Remote data fetch) node

This node retrieves data from a remote data source.

Node name: SHIP

Represents: An node used in the federated system to retrieve data from a remote data source. This node is considered by the optimizer when it contains a remote plan that will not be inspected by the optimizer. A SHIP node sends an SQL or XQuery SELECT statement to a remote data source to retrieve the query result. The SELECT statement is generated using the SQL or XQuery dialect supported by the data source, and can contain any valid query as allowed by the data source.

Note: XQuery is supported by Visual Explain only.

Feedback