MySQL Heap Tables

HEAP tables are present in memory and they are used for high speed storage on temporary

  • BLOB or TEXT fields are not allowed
  • Only comparison operators can be used =, <,>, = >,=<
  • AUTO_INCREMENT is not supported by HEAP tables
  • Indexes should be NOT NULL

Leave a Reply

Your email address will not be published. Required fields are marked *