Re: optimize hash join between 2 large tables
- From: Mladen Gogala <mgogala@xxxxxxxxxxxxxxxxxxxx>
- To: Paula_Stankus@xxxxxxxxxxxxxxx
- Date: Fri, 21 Jan 2005 09:58:23 -0500
Paula_Stankus@xxxxxxxxxxxxxxx wrote:
>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???
>
>
You can put them in a 16K blocksize tablespace. That will speed up the
full table scan, but may
also have some undesired consequences as Oracle will need to maintain
another buffer pool, another
set of LRU latches, probably another DBWR and it can be quite an
interesting thing in conjunction
with workarea_size_policy set to auto.
--
Mladen Gogala
Oracle DBA
Ext. 121
--
//www.freelists.org/webpage/oracle-l
Other related posts:
