Multi-core parallelism or intra-partition parallelism in
DB2, which can be enabled by a configuration parameter intra_parallel, allows
query execution to be parallelized by dividing the work among subagents. As a result, CPU resources on a multi-core machine
can be better utilized and query elapsed time can be reduced. It is especially beneficial to long-running
warehouse queries. Also, it does not
require any form of data partitioning.
DB2 has supported intra-partition parallelism for... [Continue Reading]