MERGE Table Advantages and Disadvantages-opracowanie

Nasza ocena:

3
Wyświetleń: 294
Komentarze: 0
Notatek.pl

Pobierz ten dokument za darmo

Podgląd dokumentu
MERGE Table Advantages and Disadvantages-opracowanie - strona 1

Fragment notatki:

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
one.
• 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ę

Komentarze użytkowników (0)

Zaloguj się, aby dodać komentarz