Re: optimize hash join between 2 large tables

Strickland, Mark wrote:

>If there are only a few columns in the select list, you might consider
>indexes that contain those columns along with the columns referenced in
>the where clauses so that Oracle just does index joins.
>
>

So, basically, what you are saying is that the best way of speeding up a big hash join is by
eliminating it?

-- 
Mladen Gogala
Oracle DBA
Ext. 121


--
http://www.freelists.org/webpage/oracle-l