Topic
  • 1 reply
  • Latest Post - ‏2014-02-12T08:14:49Z by YVA1_Christian_Arnoux
ftam
ftam
3 Posts

Pinned topic Federation view - serial or parallel?

‏2014-02-11T19:30:21Z |

I have a database federated with 5 remote databases (same DDL, but on different locations around the globe).  I have a federated view using "union all" from the remote tables.  My question is: Does DB2 fetch the remote records in serial or parallel fashion?  The reason I ask is that each location has a certain latency.  Should I expect to the view performance to be the sum of the latency from all locations?