2 ms·
That is essentially what they are. The merge algorithm merges your query with the query of the view and returns the result. However, if the query of the view re
by IgorPartola 15y ago
That is essentially what they are. The merge algorithm merges your query with the query of the view and returns the result. However, if the query of the view returns a very large result set, it is much faster to pre-flight it, then select against it.
- jeltz 15y agoYeah, but letting users specify if views are MERGE or TEMPTABLE seems quite pointless. Why not always use UNDEFINED and let the planner chose. The planner knows which tables are large.