adspace


What is the purpose of using a heap table?

Answer Posted / Naz Mehdi

A Heap Table in MySQL is a non-clustered index. It stores data without any particular order, and it does not enforce any kind of unique key constraint. This can lead to faster INSERT operations but slower SELECT operations.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to Change a users password from unix shell.

1223


What is the current mysql version?

1105


Which statement is used in a select query for partial matching?

1247


What is current version of mysql?

1084