Home / DeveloperSection / Interviews / What are HEAP tables in MySQL?
You haven’t finished your post yet. Are you sure you want to leave and discard your draft?
Can you answer this question?
Sumit Kesarwani
HEAP tables are in-memory. They are usually used for high-speed temporary storage.
No TEXT or BLOB fields are allowed within HEAP tables.
You can only use the comparison operators = and ‹=›.
HEAP tables do not support AUTO_INCREMENT.
Indexes must be NOT NULL.
You have need login or register for voting of answers or question.
Sumit Kesarwani
10-Feb-2014HEAP tables are in-memory. They are usually used for high-speed temporary storage.
No TEXT or BLOB fields are allowed within HEAP tables.
You can only use the comparison operators = and ‹=›.
HEAP tables do not support AUTO_INCREMENT.
Indexes must be NOT NULL.