Meaning of Heap tables

Question

What do you mean by Heap tables? And also define its characteristics?

Answer 1

a.    HEAP tables are found in memory.

b.    HEAP used for high speed storage on temporary basis.

Their characteristics are as follows:

a.    They do not allow BLOB or TEXT fields.

b.    Only comparison operators like =, <,>, = >,=< , can be used with them.

c.    HEAP tables does not support AUTO_INCREMENT

d.    Indexes should be NOT NULL