Explain about HEAP table?
By Arun Desai
Explain about HEAP table?????
Teacher SiliconIndia replied to Arun Desai Thursday, March 18, 2010
Hi Arun,
This type of table is stored in the memory. Speed of execution of this table is very commendable. There are associated disadvantages associated with this table the primary one being loss of stored memory which occurs when there is power failure and can cause the server to run out of memory. Columns with AUTO_INCREMENT, TEXT characteristics and BLOB are not supported.
