On 10/3/06, Carlo Stonebanks <stonec.register@xxxxxxxxxxxx> 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