> But the message I was replying to was a similar union query, and I was
> thinking that that person might be having a similar initial intuitive
> reaction, "well, it looks kinda the same." I just wanted to note that
> you need to check this stuff with explain, rather than
> blindly assuming
> you know what's going on.
I had a "union all" view, which is actually a quite different animal than
a "union" view which needs to eliminate duplicates before further processing.
Andreas