union in one go [message #481170] |
Mon, 01 November 2010 08:47 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
prashant_ora
Messages: 196 Registered: July 2010
|
Senior Member |
|
|
I have one query like
a--query1
union
b--query2
union
c--query3
and get the output in 30 seconds.
If i run the separte seprate query it took 10 seconds each. Now my question is that can i run all the three query spearetly in one process, so that in 10 seconds i can get thecombined output. Please advice.
|
|
|
Re: union in one go [message #481172 is a reply to message #481170] |
Mon, 01 November 2010 08:58 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
Not really no.
Do you realise that UNION does an implicit distinct on the result?
Your question would imply that such a distinct operation is unecessary with your queries. In which case you should use UNION ALL instead.
|
|
|
|
|
Re: union in one go [message #481176 is a reply to message #481174] |
Mon, 01 November 2010 09:23 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
prashant_ora
Messages: 196 Registered: July 2010
|
Senior Member |
|
|
No i want to insert the output of each query seprately,means in parralel,because if i run it one go, it took 30 seconds, but if i run it every query one by one, it took 10 seconds, so finally i want to get the output in 10 seconds, is there any way.
|
|
|
|