A heap is a table without a clustered index. Data is stored in the heap without specifying an order. Usually data is initially
stored in the order in which is the rows are inserted into the table, but the Database Engine can move data around in the heap
to store the rows efficiently; so the data order cannot be predicted.
Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.
Get Started
Comments
Leave a Comment