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)
E. Rohou, B. Swamy, und A. Seznec. Proceedings of the 13th Annual IEEE/ACM International Symposium on Code Generation and Optimization, Seite 103--114. Washington, DC, USA, IEEE Computer Society, (2015)
H. Inoue, und T. Nakatani. Proceedings of the 24th ACM SIGPLAN Conference on Object Oriented Programming Systems Languages and Applications, Seite 137--154. ACM, (2009)
B. Claudel, Q. Sabah, und J. Stefani. Formal Techniques for Distributed Objects, Components, and Systems, Volume 9039 von Lecture Notes in Computer Science, Springer, (2015)