Walmart Labs Interview Question | Table
Question
What is a table called, if it has neither Cluster nor Non-cluster Index? What is it used for?
in progress
2
Statistics
4 years
2 Answers
890 views
Great Grand Master 0
Answers ( 2 )
It is called unindexed table or heap and it is mainly used for fast storing of data.
Unindexed table or Heap.
A heap is a table that does not have a clustered index and, therefore, the pages are not linked by pointers.
Unindexed tables are good for fast storing of data.