Question

Difference between interquery and intraquery parallelism

Answer 1

Answer:

your answer will be

Explanation:

Intra-query parallelism is achieved when several processors cooperate in the execution of a single query to improve the query's response time. ... Operator-level parallelism is obtained by executing concurrently several operators of the same query.

Answer 2

Answer:

They are two types of parallelism in parallel database.

Explanation:

Interquery Parallelism

• Easiest form of parallelism, where different queries or transactions execute in parallel with one another.

• Transaction throughput can be increased.
• Primary Use: Scale up transaction processing system

Intraquery Parallelism

• It refers to the execution of a single query in parallel on multiple processors & disks.
• Use: Speed up long running queries.