Improving Performance of Distributed Queries

The optimizer assumes that access to a row from a remote database takes longer than access to a row in a local database. The optimizer estimates include the cost of retrieving the row from disk and transmitting it across the network. For an example of this higher estimated cost, see Displaying a Query Plan for a Distributed Query.