Re:Disaster: MySQL 5.5 Flushing
by IgorPartola on Monday September 19, 2011 @11:42AM
(#3013952)
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.
[ Parent
| on HN ]