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.

• What is the difference between "procedure" and "function"?
• What is the difference between "translate" and "replace"?
• What is DYNAMIC SQL method ?
• What is the use of Analyzing the tables?
• How to run SQL script from a Unix Shell?

Only registered users can write comments.
Please login or register.