Question
What can excessive index fragmentation cause in a rowstore warehouse table?
Select an option. Your answer will be checked instantly.
Correct Answer: C. Additional page reads and less efficient range scans
Explanation:
Fragmentation disrupts page order and may reduce page density.
Reorganization or rebuilding can improve certain scan and maintenance patterns.
Leave a Reply