What are HEAP tables in MySQL?
By Balu Prasad
What are HEAP tables in MySQL???
Teacher SiliconIndia replied to Balu Prasad Thursday, March 18, 2010
Hi Balu,
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.
