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

Oracle's parallel degree is not automatically set to 2 for indexes with fewer than 5000 leaf blocks. Parallel execution degree is determined by initialization parameters, object-level settings, and the cost-based optimizer - not a fixed threshold of 5000 blocks.

Keep practicing — related questions