Over 10 Million Study Resources Now at Your Fingertips

Download as :
Rating : ⭐⭐⭐⭐⭐
Price : $10.99
Pages: 2

The entire environment shuts down and then restarts


Chapter 5

While DB2 employs static parallelism across its partitions, it also uses intra-partition, or dynamic, parallelism. Dynamic parallelism allows the optimizer to assign a specific number of parallel tasks within each parti-tion, based on individual query requirements.

This approach has a number of implications. Fewer partitions are needed because parallel query performance is not constrained by the num-ber of partitions. Consider the impact on a simple query:

Technical Architecture and Data Management Foundations


Minimum messages required for one partition to redistribute rows from one table (8 partitions)
Static and dynamic parallelism.

Figure 5.9 Dynamic parallelism after redistribution.

How It Works
Login account
Login Your Account
Add to cart
Add to Cart
Make payment
Document download
Download File
PageId: ELI0BFB2A8
Uploaded by :
Page 1 Preview
the entire environment shuts down and then restart
Sell Your Old Documents & Earn Wallet Balance