Hi,

just assume that

SQL Query :

SQL1 UNION ALL SQL2

separately exection times are

SQL1 -- 5 seconds (total count - 5,00000)

SQL2 -- 10 seconds (total count - 4,00000)

if I use UNION ALL. it takes 30 minutes to complete the execution.why it takes that much time if I use UNION ALL.?

Thanks