On 10/3/06, Carlo Stonebanks <stonec(dot)register(at)sympatico(dot)ca> wrote:
> Please ignore sample 1 - now that I have the logging feature, I can see that
> my query generator algorithm made an error.
can you do explain analyze on the two select queries on either side of
the union separatly? the subquery is correctly written and unlikely
to be a problem (in fact, good style imo). so lets have a look at
both sides of facil query and see where the problem is.
merlin