Outer join = full table scan

I've noticed that using an outer join will cause a full table scan. It doesn't seem to matter that all relevant columns have indexes. Is this an Oracle limitation?

To get around it, I've re-written the query (queries) using a "union". This is obviously a little tedious and not very elegant.

Is there anything else that can be done?

Thanks in advance.

-Allen

-- 
Allen Hadden
Systems Engineer
Taratec Development Corporation
ahadden_at_taratec.com