Hello friends,
If a table does not have neither Cluster nor Non-cluster Index then what we call it ? What is it used for?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Satyapriya NayakPosted Oct 20, 2011, 4:18 AM
A table without Cluster and non-cluster indexes is also known as a heap.
Unindexed tables are good for fast storing of data.
Thanks
Prabhu RajaPosted Oct 20, 2011, 3:13 AM
we can call it as Heap or Unindexed Table. A heap is a table which has Non-Clustered index, will not sort the data Physically.
Javeed M ShaikhPosted Oct 19, 2011, 5:28 PM
If the table is not having Cluster or Non-Cluster Index it is called a heap and therefore, the pages are not linked by
pointers. The IAM pages are the only structures that link the pages in a table together.
What it is used for?
Unindexed tables are good for fast storing of data. Many times it is better to drop all indexes from table
and than do bulk of inserts and to restore those indexes after that.
Please do not forget to mark "Accepted Answer".