Register now or log in to join your professional community.
Basically tables that are present in the memory and used as temporary table are HEAP tables.
When creating a HEAP table in MySql, user needs to specify the TYPE as HEAP. These tables are now more commonly known as memorytables. These memory tables never have values with data type like “BLOB” or “TEXT”. They use indexes which make them faster.
When creating a HEAP table in MySql, user needs to specify the TYPE as HEAP. These tables are now more commonly known as memorytables.