What Is Heap Table?

1.	What Is Heap Table?
Answer» Tables that are present in MEMORY is KNOWN as HEAP tables. When you create a heap table in MySQL, you should need to specify the TYPE as HEAP. These tables are commonly known as memory tables. They are used for HIGH SPEED storage on temporary basis. They do not allow BLOB or TEXT fields. Tables that are present in memory is known as HEAP tables. When you create a heap table in MySQL, you should need to specify the TYPE as HEAP. These tables are commonly known as memory tables. They are used for high speed storage on temporary basis. They do not allow BLOB or TEXT fields.

Answer»

Tables that are present in MEMORY is KNOWN as HEAP tables. When you create a heap table in MySQL, you should need to specify the TYPE as HEAP. These tables are commonly known as memory tables. They are used for HIGH SPEED storage on temporary basis. They do not allow BLOB or TEXT fields.

Tables that are present in memory is known as HEAP tables. When you create a heap table in MySQL, you should need to specify the TYPE as HEAP. These tables are commonly known as memory tables. They are used for high speed storage on temporary basis. They do not allow BLOB or TEXT fields.

Discussion

No Comment Found

Related InterviewSolutions

What Is Sqlyog?
How Do You Backup A Database In Mysql?
What Are The Differences Between Mysql_fetch_array(), Mysql_fetch_object(), Mysql_fetch_row()?
What Are The Advantages Of Myisam Over Innodb?
What Is The Usage Of Enums In Mysql?
How Is Myisam Table Stored?
What Is The Use Of Mysql_close()?
What Is Mysql Data Directory?
How Do You Determine The Location Of Mysql Data Directory?
What Is The Usage Of Regular Expressions In Mysql?