No, I do not recommend performing your join outside of the database! Oracle is more than capable of performing such a join in an efficient fashion. Let Oracle do what it does best, rather than trying to build your own solution.
There are many options and techniques available to help you solve this problem. Have you examined the optimizer plan for the query in question? Are the tables indexed on the join columns, and any other columns that are referenced in the query predicate? Are table and index statistics up to date? Have you tried using optimizer hints to force different join methods and observing which one performs best?
Dig Deeper on Oracle and SQL
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.