UNION ALL Task - Does it give good perfomance?

  • I have to join two different tables with varying column count(with some similarity in column names) as well as row count, for this i used UNION ALL task in SSIS. Does UNION ALL task give better performance? or Is there any alternative for this ?

    Thanks in advance

  • UNION ALL won't work unless you have the same number of columns returned in both queries.

    From a performance standpoint, I have heard lectures that swing both ways. One says that it takes more time to perform multiple queries while another says that multiple smaller queries will run faster so it depends largely upon your data. I would try it both ways to see what works best. Personally, I use UNION ALL fairly frequently and don't have any problems with it. My largest database is just shy of 50GB in size so I'm certainly not playing with a huge amount of data...

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply