Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can we create reports taking data from heap tables?
Thanks
TR
Heap tables? What are those?
Hi ArchanaReddy
Where can we find heap tables?
Here you go!
https://msdn.microsoft.com/en-GB/library/hh213609(v=sql.110).aspx
![]() |
---|
There are sometimes good reasons to leave a table as a heap instead of creating a clustered index, but using heaps effectively is an advanced skill. Most tables should have a carefully chosen clustered index unless a good reason exists for leaving the table as a heap. |