Home > DeveloperSection > Interviews > What are HEAP tables in MySQL?

Posted on    February-10-2014 12:01 AM

 1 Answer(s)
  1104  View(s)
Rate this:

Sumit Kesarwani

Total Post:782

Posted on    February-10-2014 1:00 AM

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.

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

Follow MindStick