MERGE Table Advantages and Disadvantages
MERGE tables 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
• Obtain more 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 more efficient searches. If you know exactly 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.
... zobacz całą notatkę