Organizational Research By

Surprising Reserch Topic

Experts Most Trusted Topic


about Heap tables?


- HEAP tables are found in memory. 
- They are used for high speed storage on temporary basis.
 
Some of their characteristics are: 
- They do not allow BLOB or TEXT fields. 
- Only comparison operators like =, <,>, = >,=< , can be used with them. 
- AUTO_INCREMENT is not supported by HEAP tables
- Indexes should be NOT NULL
 

asked Sep 13, 2013 in MYSQL by rajesh
edited Sep 12, 2013
0 votes
15 views



Related Hot Questions



Walkin Jobs Opening



Government Jobs Opening


...