Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.
heap is a table without clustered index.
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.