What are Heap tables?
Heap tables are in-memory tables used for high-speed temporary storage. But, TEXT or BLOB fields are not allowed within them. They also do not support AUTO INCREMENT.
| Is This Answer Correct ? | 0 Yes | 0 No |
How MySQL Optimizes DISTINCT?
How do I delete a row in mysql?
How can we change the data type of a column of a table?
what is JOIN? Give example & types of join?
14 Answers iMedia, Millennium, RAM Software, Satyam,
How do I start mysql from command line?
What is regexp?
Write command to import an mysql file?
Which storage engine is best in mysql?
How many columns can you create for an index?
Can we store files in mysql?
What is the difference between a heap table and temporary table?
How to make a column bigger and delete unique from table.
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)