MySQL Forums
Forum List  »  Merge Storage Engine

Re: Use of merge tables
Posted by: James Day
Date: December 25, 2005 03:59PM

Partitioning can't replace merging, in general, because you can easily move a table into or out of a merge but can't do that if the partitioning is within a single partitioned table. Has applications in scenarios like archiving or optimising (with an ALTER TABLE ... ORDER BY).

Options: ReplyQuote


Subject
Views
Written By
Posted
11089
November 24, 2005 05:42PM
7917
November 25, 2005 02:36AM
Re: Use of merge tables
7600
December 25, 2005 03:59PM
6636
September 03, 2008 12:05AM


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.