Meaning of Heap tables
What do you mean by Heap tables? And also define its characteristics?
Expert
a. HEAP tables are found in memory.
b. HEAP used for high speed storage on temporary basis.
Their characteristics are as follows:
a. They do not allow BLOB or TEXT fields.
b. Only comparison operators like =, <,>, = >,=< , can be used with them.
c. HEAP tables does not support AUTO_INCREMENT
d. Indexes should be NOT NULL
Define the term Posting in database.
How can we convert between Unix & MySQL timestamps?
Define the Synonyms in Structure Query Language.
Explain about the Distributed Query in the SQL Statement.
What are the limits applicable when creating views?
How is MyISAM table stored?
Describe the term sparse filtered index.
Illustrates the JOIN commands?
What is Null value function?
18,76,764
1923334 Asked
3,689
Active Tutors
1425612
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!