MERGE ta bies can help you solve the following problems:
• Easily manage a set of log tables. For example, you can put data from different months into separate
tables, compress some of them with myisampack, and then create a MERGE table to
use them as
one.
• Obtain morę speed. You can split a large read-only table based on some criteria, and then put
individual tables on different disks. A MERGE table structured this way could be much faster than
using a single large table.
• Perform morę efficient searches. If you knowexactly what you are looking for, you can search in just
one of the underlying tables for some queries and use a MERGE table for others. You can even have
many different MERGE tables that use overlapping sets of tables.