Re: optimize hash join between 2 large tables

  • From: Mladen Gogala <mgogala@xxxxxxxxxxxxxxxxxxxx>
  • To: "Strickland, Mark" <Mark.Strickland@xxxxxxxxxxxx>
  • Date: Fri, 21 Jan 2005 17:27:25 -0500

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


Other related posts: