On Tue, Mar 29, 2011 at 7:16 PM, Samuel Gendler
<sgendler@ideasculptor.com> wrote:
> Is there any performance benefit to revamping the workload such that it issues
> a single:
> insert into (...) select ... UNION select ... UNION select
> as opposed to 3 separate "insert into () select ..." statements.
I wouldn't expect any difference - if you used UNION ALL (union will
be equivalent to insert into () select DISTINCT ...)