Cluster And Non-Cluster in a Table

Question

Hello friends If a table does not have neither Cluster nor Non-cluster Index then what we call it ? What is it used for?

Satyapriya Nayak · Answer

Hi Michell 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 Raja · Answer

Hi 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 Shaikh · Answer

Hi Michell 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.