| What is heap table and other name of these table in MySQL?
In MySQL tables that present in memory is known as HEAP tables. But when we create Heap table in MySQL we need to specify the type as HEAP. And these tables are commonly known as memory tables. Heap tables are used for high-speed storage on a temporary basis. They do not allow BLOB or TEXT fields. | | |