What are HEAP tables in MySQL?

  • Sharad Jaiswal
  • 22nd Feb, 2018

1 answer(s) :

  •   Reply


    13th Oct, 2019

    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.

Post your Answer :

Valid name is required.

Valid name is required.

Valid email id is required.