-
Oracle performance issue with "UNION ALL" in 10g
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|