Re: tune between query/join

2011/10/21 David Fitzjarrell <oratune@xxxxxxxxx>:
> The original 'join' produces useless noise along with some valid data buried 
> deep within.

As we don't know the OPs original problem it is hard to say whether it
is useless noise or valuable solution FOR HIM.
Generally join doesn't mean only eaquality, join predicate can be
everything not only (=) meaning equi join, but also any other
condition. How necessary and appropriate it is in this case of course
is another question.
And yes - if you have anything other than equi join, then the only
solution for actual join mechanism remains either nested loops
(generally not good for big datasets) or merge join. Hash joins are
possible only if there is equality and respectively hashes to compare.

Gints Plivna
http://www.gplivna.eu
--
http://www.freelists.org/webpage/oracle-l

Other related posts: