MySQL Forums
Forum List  »  Merge Storage Engine

Re: Difference between using Merge vs. symbolic-links approach?
Posted by: KimSeong Loh
Date: June 11, 2007 04:02PM

For 1, I am not aware of this limitation, I have to check.

For 2, I suspect if you do a simple view like select * from anothertable, this should be using the ALGORITHM=MERGE instead of TEMPTABLE, MERGE algorithm should be able to reuse the indexes in the underlying table. With TEMPTABLE algorithm the indexes of the underlying table is only used to generate the view result, cannot be used on the actual query, so fulltext index is not usable here.
If you do UNION of multiple tables in the view, the algorithm could be TEMPTABLE.
Anyway, I have not done fulltext in this manner, so cannot be sure.

Options: ReplyQuote

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.