To sreddy about Nested loop/Hash Join

[Shestakov]

Fist method (with garantee of switch to NESTED LOOP)

alter session set hash_join_enable=false;
select ....
...
/
alter session set hash_join_enable=true;
Plus try to increase parametes:

OPTIMIZER_INDEX_CACHING ~ 70..90
OPTIMIZER_INDEX_COST_ADJ ~ 200..500

Second method (not garantee of switch to NESTED LOOP)

select /*+ first_rows */
...

[sreddy]

Thanks a lot. I did delete thread cuz, there was someother issue with it. Using NL hint helped me to force Nested Loops but, performance is gone worst than before (when it was using HASH_JOIN).