Which of the following has the ability to subdivide a single query into a number of parts and replicate them concurrently using either intra-partition parallelism or inter-partition parallelism or both?
-
Degree of parallelism
-
Intra-query parallelism
-
Parallel database system
-
Parallel I/O
-
None of these
B
Correct answer
Explanation
Intra-query parallelism has the ability to subdivide a single query into a number of parts and replicate them concurrently using either intra-partition parallelism or inter-partition parallelism or both.