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 |
How do I change a procedure in mysql?
How to get last inserted id after insert data from a table in mysql?
How do I start mysql client?
How much does mysql cost?
Can I copy mysql data directory?
What is mysql command line?
Where the database is stored in mysql?
How do I delete a row in mysql?
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
Is mysql case-sensitive?
Table A has 5 rows and table B has 0 rows Cartesian join on A,B will have----rows
write a query to mysql in safe mode and to change the root password
Oracle (3253)
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)