federated query

The SQL statements and commands submitted in a pass-through session do not go through the federated query compiler.

The ultimate aim of asynchrony is to reduce the execution time of the federated query.

The following is one of many approaches to tuning federated query performance.

She currently works in the WebSphere Information Integrator Federated Query Compiler team, focusing on general federated query processing.

Awareness of all applicable remote indexes can help the federated query optimizer generate better execution plans.

Source servers may be negatively impacted by increased workload when they have to return data that is requested in a federated query.

In the above example, performance of the federated query could be improved by executing all three remote legs of the UNION at the same time.

Detailed instructions on how to interpret a FQEP can be found under the section, "Interpreting Federated Query Execution Plans. "

The federated query compiler makes a cost-based decision and makes the process of using MQTs transparent to the users.

For example, a federated query might be written in SQL and might specify access to product information.

Where does the data reside that is necessary to respond to the federated query?