top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration

What is heap table in Mysql?

+1 vote
106 views
What is heap table in Mysql?
posted Mar 10, 2017 by Kavyashree

Share this question
Facebook Share Button Twitter Share Button Google+ Share Button LinkedIn Share Button Multiple Social Share Button

2 Answers

0 votes
  • Tables that are present in the memory are called as HEAP tables.

  • When creating a HEAP table in MySql, user needs to specify the TYPE as HEAP.

  • These tables are now more commonly known as memory tables.

  • These memory tables never have values with data type like “BLOB” or “TEXT”. They use indexes which make them faster.

  • They use a hashed index and are stored in the memory.

  • This makes them very fast but if MYSQL crashes all data stored in them can be lost.

  • It is very useful as a temporary table.

  • The internal heap tables use 100% dynamic hashing without the overflow areas.

  • They do not have a problem with delete and insert.

answer Mar 11, 2017 by Shivaranjini
0 votes

Tables that are present in the memory are called as HEAP tables.

  • When creating a HEAP table in MySql, user needs to specify the TYPE as HEAP.

  • These tables are now more commonly known as memory tables.

  • These memory tables never have values with data type like “BLOB” or “TEXT”. They use indexes which make them faster.

  • They use a hashed index and are stored in the memory.

  • It is very useful as a temporary table.

  • The internal heap tables use 100% dynamic hashing without the overflow areas.

  • They do not have a problem with delete and insert.

answer May 9 by Rushabh Verma R.
Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...