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.?