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
8182
November 30, 2005 10:55AM
4956
November 30, 2005 05:41PM
Re: Merging Archive tables with MyISAM tables
4510
February 01, 2006 10:02AM
4287
February 03, 2006 12:58AM
4694
March 01, 2006 04:41PM
4452
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.