hash_area_size if not set defaults to twice sort_area_size and hash_...io_count
* db_block_size should not be more than the physical i/o supported by OS.
There is a saturaton level at beyond which if u raise this value there is not benefit.
|
Results 1 to 4 of 4
Thread: How Hash Join works?Threaded View
|
Click Here to Expand Forum to Full Width |