 |
|
 |
| |
Developer on focus
Anton Zamov is a dipl. engineer with more than 6 years of active professional
experience and many awards ...
read more>>
|
|
 |
 |
 |
|
|
|
|
| |
|
What is the difference between indexes for HEAP MyISAM and MERGE MySQL tables?
|
Some of the most important things concerning indexes for the different
table types are listed below:
MyISAM
BLOB and TEXT indexes can exist.
Null values are permissible in indexes
MERGE
A MERGE table contains no indexes of its own.
HEAP
Use a hash index stored in memory, which is very fast.
Can only use indexes with the = and <=> operators.
Cannot use an index on a column that allows NULL values.
Indexes are not used with an ORDER BY clause
|
About the author of this programming example or tutorial:
Anton Zamov is a software engineer with more than6 years
of active experience in web and software development and design.
Anton Zamov has extensive experience and broad knowledgebase
in C# and JAVA programming and has created a lot of
running e-commerce systems, portals and content management
systems using PHP and other web development technologies.
For more information about Anton Zamov, you may visit the personal web site of
Anton Zamov.
|
|
|
|
|
|
|
|
