What is the difference between a heap table and temporary table?
- 1 Answers
- 1035 Views
- I also Faced
- E-Mail Answers
Answer Posted / Shikha Kushwaha
A heap table is an unordered table in MySQL that stores data without any specific order. Heap tables do not have a clustered index, so the data is organized only by its physical location. A temporary table, on the other hand, is created for the lifetime of a connection or a single query execution and exists solely to store intermediate results during query processing. Temporary tables are typically sorted and indexed, improving query performance.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
