maria-discuss team mailing list archive
Mailing list archive
Re: 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.
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.