maria-discuss team mailing list archive

[Igor Babaev <igor@xxxxxxxxxxxx>]

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.