What is heap table?



What is heap table?..

Answer / Shiv Ram Krishanan

In MySQL, a heap table is a type of table storage that does not have an index. This means that data in the table is stored in no particular order and is accessed by scanning through the entire table, making it less efficient for queries that involve filtering or sorting data.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MySQL Interview Questions

What sql does mysql use?

1 Answers  


HOW TO FIND display the total number of weeks in the year of 1998 IN EMP TABLE

1 Answers  


How many values can the SET function of MySQL take?

2 Answers   Creative Informatics,


How to Creating a new user. Login as root. Switch to the MySQL db. Make the user. Update privs.

1 Answers  


How do you rename a table in mysql?

1 Answers  


How do I rename a table in mysql workbench?

1 Answers  


what are the optimization techniques for Query optimization performance issues and faster execution of queries

2 Answers   Infosys, Sierra Atlantica,


How to print message in mysql trigger?

1 Answers  


How do I kill a mysql query?

1 Answers  


What is mysqli_free_result?

1 Answers  


How to show certain selected rows with the value "pcds".

1 Answers  


How to get data from mysql in php?

1 Answers  


Categories