How to define a heap
Prithvi Nath Pandey
A table which does not contains any physical ordered index aka clustered index is called as the heap. The data in heap is not sorted physically. If a table contains any non-clustered index but no clustered index, it means there is no physical ordering of data only logical ordering happens hence it is a heap.