What are HEAP tables in MySQL?
- Sharad Jaiswal
- 22nd Feb, 2018
1 answer(s) :
-
Reply
"
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.
Farheen
13th Oct, 2019