Home > DeveloperSection > Interviews > What is HEAP table?

Posted on    April-23-2011 3:44 AM

 MYSQL MYSQL 
Ratings:
 1 Answer(s)
  1024  View(s)
Rate this:

Monaj Singh
Monaj Singh

Total Post:48

Points:240
Posted on    April-23-2011 12:00 AM

Tables that are present in the memory are called as HEAP tables.A heap is a table without a clustered index. One or more nonclustered indexes can be created on tables stored as a heap. Data is stored in the heap without specifying an order. Usually data is initially stored in the order in which is the rows are inserted into the table,

Modified On Mar-15-2016 07:40:09 AM

Don't want to miss updates? Please click the below button!

Follow MindStick