Question
Why can tempdb become important during large warehouse queries?
Select an option. Your answer will be checked instantly.
Correct Answer: C. Sorts, hashes, spills, and temporary results may use it heavily
Explanation:
Complex joins and aggregations may require work space beyond available memory.
Proper tempdb sizing and I/O design reduce contention and spill penalties.
Leave a Reply