472,114 Members | 2,191 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,114 software developers and data experts.

Type All in Explain for Union Query

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.
Aug 11 '06 #1
0 2008

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by S.Tobias | last post: by
13 posts views Thread by zacariaz | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.