MySQL Forums
Forum List  »  Views

About algorithms
Posted by: Federico Razzoli
Date: March 17, 2005 05:13AM

Documentation ( tells there are 2 ALGORITHMs wich can be possibly used with a VIEW: TEMPTABLE and MERGE. Doc does not say anything about these (or I can't find any other information). I guess that TEMPTABLE internally creates a temporary table containing VIEW's data and MERGE internally uses a MERGE basetable.

Still, that does not say us very much: when should we prefer TEMPTABLE and when should we prefer MERGE? Can MERGE be used for a VIEW wich does not use only MyISAM tables? What happens if we use "ALGORITHM=UNDEFINED" or we omit that clause?

Options: ReplyQuote

Written By
About algorithms
March 17, 2005 05:13AM
March 17, 2005 11:29PM
March 23, 2005 03:44AM
October 18, 2005 07:53AM
October 18, 2005 07:11PM

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.