What is the purpose of using a heap table?



What is the purpose of using a heap table?..

Answer / 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

More MySQL Interview Questions

How do I change a procedure in mysql?

1 Answers  


How to get last inserted id after insert data from a table in mysql?

1 Answers  


How do I start mysql client?

1 Answers  


How much does mysql cost?

1 Answers  


Can I copy mysql data directory?

1 Answers  


What is mysql command line?

1 Answers  


Where the database is stored in mysql?

1 Answers  


How do I delete a row in mysql?

1 Answers  


Fname Lname City Pin ramesh kumar salem 365241 Query to generate a code having the firstletter of Fname,Lname & 3letter of city Last 3letter of pin,all in capital letters

3 Answers  


Is mysql case-sensitive?

1 Answers  


Table A has 5 rows and table B has 0 rows Cartesian join on A,B will have----rows

2 Answers  


write a query to mysql in safe mode and to change the root password

1 Answers  


Categories