Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: optimize hash join between 2 large tables

RE: optimize hash join between 2 large tables

From: <Paula_Stankus_at_doh.state.fl.us>
Date: Fri, 21 Jan 2005 09:15:06 -0500
Message-ID: <E518A02B320C8D4E97D99A8C5464802105A8662B@dohsmailhq01.doh.ad.state.fl.us> 





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???

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


Received on Fri Jan 21 2005 - 09:24:27 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US