IBM Db2 Big SQL 7.1.0

Understanding access plan optimization decisions

This section lists typical optimization questions, and areas you can investigate to improve performance.

Why isn't a join between two nicknames of the same data source being evaluated remotely?
You can check elements of the join operation, join predicates, and the number of rows in the result to evaluate why a join between two nicknames of the same data source is not evaluated remotely
Why isn't the GROUP BY operator being evaluated remotely?
Why is the statement not being completely evaluated remotely?
Why does a plan generated by the optimizer and completely evaluated remotely, have much worse performance than the original query executed directly at the remote data source?

Parent topic: Global optimization