Type All in Explain for Union Query

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

I am trying to optimize a union query for which the union result is a
type of all, but when each component is explained the types are either
ref or eq_ref.  There are quite a few tables and views which form the
bases for the ultimate query, so I don't think posting all of those
would be viable.  I am just looking for pointers.

Site Timeline