Advantages of Inter-Query Parallelism
1) It is the easiest form of parallelism to support in a database system, particularly shared memory parallel system.
2) It increases the transaction throughput. That is, number of transactions executed in a given time can be increased.
3) It scales-up a transaction processing system to support a larger number of transactions per second.
Disadvantages of Inter-Query Parallelism
1) The response time of individual transaction remains almost same as if the transaction were run in isolation.
2) It is more complicated to support in a shared disk or share nothing architecture.
3) It does not help in speeding up long running queries, since each query runs sequentially.