EmergencyEMERGENCY? Get 24/7 Help Now!

A workaround for the performance problems of TEMPTABLE views

 | May 19, 2010 |  Posted In: Insight for Developers, MySQL

MySQL supports two different algorithms for views: the MERGE algorithm and the TEMPTABLE algorithm. These two algorithms differ greatly. A view which uses the MERGE algorithm can merge filter conditions into the view query itself. This has significant performance advantages over TEMPTABLE views. A view which uses the TEMPTABLE algorithm will have to compute the […]

Read More