Multiple choice technology databases

If the number of leaf blocks of index , scanned is less than 5000 then degree of parallelismis 2?

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Parallel degree depends on many factors beyond just leaf block count: system configuration, optimizer cost calculations, table size, and available CPU resources. A fixed rule of 5000 blocks = degree 2 doesn't exist. The parallel degree is determined by the optimizer based on total cost, not just block count.

Keep practicing — related questions