MySQL Forums
Forum List  »  Merge Storage Engine

Re: merge and temporary tables
Posted by: Ingo Strüwing
Date: January 30, 2006 03:51AM

MERGE is not an option in table creation. A MERGE table is kind of a view that accesses other tables for the data. In contrast to a view, the MERGE table cannot be expressed by a SELECT command. It is a concatenation of its sub-tables.

Since a MERGE table does not contain data or indexes itself, it can be created and ropped quickly on demand.

The MERGE table and all of its sub-tables must have the same layout with minor exceptions in index definitions of the MERGE table itself. If your day tables are temporary tables, the MERGE table must be temporary too.

Regards

Ingo Strüwing, Senior Software Developer - Storage Engines
MySQL AB, www.mysql.com

Options: ReplyQuote


Subject
Views
Written By
Posted
6041
January 29, 2006 01:22PM
Re: merge and temporary tables
3802
January 30, 2006 03:51AM
3965
January 30, 2006 03:10PM
4679
January 31, 2006 03:35AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.