Re: Merging Archive tables with MyISAM tables
Hi Kayra
Until 5.1 is ready, couldn't you use a VIEW with a UNION SELECT over both the ARCHIVE and the MyISAM table (of the same structure) to achieve the same result as with a MERGE (on only MyISAM) or a PARTITION? (Didn't try it yet - but shouldn't that work?)
Cheers,
Beat
Subject
Views
Written By
Posted
8058
November 30, 2005 10:55AM
4876
November 30, 2005 05:41PM
Re: Merging Archive tables with MyISAM tables
4444
February 01, 2006 10:02AM
4227
February 03, 2006 12:58AM
4623
March 01, 2006 04:41PM
4397
March 01, 2006 08:48PM
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.