bookmark

MySQL :: MySQL 5.0 Reference Manual :: 18.4.2 View Processing Algorithms


Description

If the MERGE algorithm cannot be used, a temporary table must be used instead. MERGE cannot be used if the view contains any of the following constructs: * Aggregate functions (SUM(), MIN(), MAX(), COUNT(), and so forth) * DISTINCT * GROUP BY * HAVING * LIMIT * UNION or UNION ALL * Subquery in the select list * Refers only to literal values (in this case, there is no underlying table)

Preview

Tags

Users

  • @carlfischer

Comments and Reviews