View performance

from the Artful MySQL Tips List


Generally, MySQL merges a View into the query where it occurs, if it can, otherwise it runs he View separately, storing the result in a temporary table. Since 5.7, MySQL handles FROM clause subqueries and such Views the same.

Which isn't to say all is now well with MySQL Views, see http://www.mysqlperformanceblog.com/2007/08/12/mysql-view-as-performance-troublemaker/.



Return to the Artful MySQL Tips page