What are HEAP tables in MySQL?
4002
10-Feb-2014
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.