Re: [Maria-discuss] why does UNION ALL use a temp table?

MARK CALLAGHAN wrote:

Why does UNION ALL use a temp table? Many users are surprised by this. It would be faster to return rows from each branch of a UNION ALL query directly to the network.

Mark, Yes, it would be faster. Yet, I'm afraid that changing the current implementation of UNION ALL is not a matter of a hundred of lines. Of course if somebody could find a sponsor for this optimization we would resolve the problem much sooner. Regards, Igor.