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

Last updated 16 Aug 2019

Return to the Artful MySQL Tips page