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
7902
November 30, 2005 10:55AM
4804
November 30, 2005 05:41PM
Re: Merging Archive tables with MyISAM tables
4384
February 01, 2006 10:02AM
4172
February 03, 2006 12:58AM
4556
March 01, 2006 04:41PM
4334
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.