Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: optimize hash join between 2 large tables
Hi,
Set hash_area_size bigger if you're using hash join. If doing the job serially, set db_block_multiblock_read_count to maximum, if with parallel, ensure that right number of slaves and optimal execution plan is used (e.g. no serial operations in the middle of parallel execution flow), also you could test whether setting _db_file_direct_io_count larger helps in your case...
Tanel.
> 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
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jan 21 2005 - 11:01:19 CST
![]() |
![]() |