🎴 Flashcard Mode
Database Administration and SQL Best Practices
Card1 / 19
Mastered0
Review0
QuestionClick to flip
If the number of leaf blocks of index , scanned is less than 5000 then degree of parallelismis 2?
AnswerClick to flip back
A
False
💡 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.