RE: optimize hash join between 2 large tables

  • From: <Paula_Stankus@xxxxxxxxxxxxxxx>
  • To: <mgogala@xxxxxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 21 Jan 2005 09:15:06 -0500

Other then use sort_area_size to sort in memory and parallel query what
can be done to optimize a pull of 2 large tables joined together where
most of the rows from both tables are selected???

Other related posts: