The problem of concurrency control is more complex in a distributed database.

In a semijoin, only the joining attribute is sent from one site to another, and then only the required rows are returned.

The semijoin approach saves network traffic.

The cost to perform a snapshot refresh may depend on whether the snapshot is simple or complex.

Data replication is favored where most process requests are read-only and where the data are relatively static.