Question
What is a heap in SQL Server?
Select an option. Your answer will be checked instantly.
Correct Answer: D. A table without a clustered index
Explanation:
Heap rows are not organized by a clustered key.
Heaps can load quickly in some staging cases but may be inefficient for repeated access.
Leave a Reply