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

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register.