Posted On: Feb 22, 2018
Heap tables are usually used for the purpose of temporary and high-speed temporary storage. Heap tables can also be defined as in-memory. Within heap tables, BLOB or TEXT fields are not allowed. Only comparison operators like = and <=> can be used. The indexes have to be NOT NULL and these tables do not upkeep AUTO_INCREMENT.
Never Miss an Articles from us.