Query [message #481207] |
Mon, 01 November 2010 16:33 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ajaykumarkona
Messages: 399 Registered: August 2010
|
Senior Member |
|
|
Hi All,
I am facing a problem with query.
In the query we are using UNION .If we run individually then it's working fine.
If we union then the query is executing for long time And we are not getting result .
please help me.
Thanks in advance.
|
|
|
|
|
|
|
Re: Query [message #481236 is a reply to message #481213] |
Tue, 02 November 2010 02:07 ![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) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68678 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
ajaykumarkona wrote on Tue, 02 November 2010 00:39I have to fetch distinct records only
So there is no more question, you want distinct values, you have to use UNION, if you want more help post what is requested in BlackSwan's link.
Regards
Michel
[Updated on: Tue, 02 November 2010 02:11] Report message to a moderator
|
|
|
Re: Query [message #481251 is a reply to message #481236] |
Tue, 02 November 2010 03:50 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
Roachcoach
Messages: 1576 Registered: May 2010 Location: UK
|
Senior Member |
|
|
Make sure your individual "test runs" are actually returning all the rows and not first n.
In what way would you "not get a result" using the union?
|
|
|