Re: Using UNION instead of OR helps...
Posted by:
James H
Date: March 26, 2010 07:12AM
I could run two separate queries, then combine the result sets in my Java code without too much effort. I'd face a bit of a problem in Java doing the ORDER BY and LIMIT stuff that I have outside of the UNION queries - I would rather keep this in my SQL code as I've experienced Java being really slow when sorting big result sets.
Anyway, UNION with INNER JOINS seems to be working reasonably well, so I'm going to leave it like that for the time being.
Thanks for all your help.
Subject
Views
Written By
Posted
5335
March 24, 2010 04:43AM
2480
March 24, 2010 09:55AM
2380
March 24, 2010 04:11PM
3829
March 24, 2010 06:30PM
2677
March 24, 2010 11:20PM
2515
March 25, 2010 04:50AM
2249
March 25, 2010 06:32AM
Re: Using UNION instead of OR helps...
3667
March 26, 2010 07:12AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.