What is the difference between indexes for HEAP MyISAM and MERGE MySQL tables? free example, tutorial, source code

home page latest news web development curriculum vitae scripts contact me

• C# (Microsoft .NET)
• JAVA
• Dynamic HTML
• PHP & MySQL
• ASP.NET - C# & VB.NET
• Perl & CGI
• C | C++
• Vector Markup Language
• SMIL
• Assembler
• Databases
• Wap Development
• Web site promotion
• Web Marketing

What is the difference between indexes for HEAP MyISAM and MERGE MySQL tables?

(Free programming example written by Anton Zamov.
Find more free examples on "The ultimate source for developers" )

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

Jobs Portal, poweful jobs board software

PHP Mall, multi vendors mall website software

Car Portal, php script for auto classifieds websites

NetArt Media, software products and services

Real Estate Portal, web software for real estate portals

Blog System, multi user blog hosting script

PHP Store, powerful e-commerce system written in PHP