WHAT ARE HEAP TABLES IN MYSQL?

Sumit Kesarwani

Total Post:782

Points:3910
Posted by  Sumit Kesarwani
MYSQL 
 1340  View(s)
Ratings:
Rate this:
  1. Sumit Kesarwani

    Post:782

    Points:3910
    What are HEAP tables in MySQL?

    HEAP tables are in-memory. They are usually used for high-speed temporary storage.

    No TEXT or BLOB fields are allowed within HEAP tables.

    You can only use the comparison operators = and ‹=›.

    HEAP tables do not support AUTO_INCREMENT.

    Indexes must be NOT NULL.

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!