| union in one go [message #481170] |
Mon, 01 November 2010 08:47  |
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  |
cookiemonster
Messages: 13958
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 |
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
