tomas.papp.me.u'know

Od Oracle 11g existuje sql hint OPT_PARAM ktorym sa da ohintovat SQL prikaz, funguje podobne ako alter session s tym ze je platny len do dobehnutia danej query

/*+ opt_param(<parameter_name> [,] <parameter_value>) */

parameter_name is the name of a parameter
 parameter_value is its value.

napriklad

select /*+ opt_param('hash_join_enabled','false') */ 
dept_no,
emp_name,
empno 
from 
emp e, dept d 
where e.ename=d.dname;

select /*+ opt_param('hash_join_enabled','false') */ 
dept_no,
emp_name,
empno 
from 
emp e, dept d 
where e.ename=d.dname;

alebo ak chceme pouzit viac

/*+ OPT_PARAM('_always_semi_join' 'off')
 OPT_PARAM('_b_tree_bitmap_plans' 'false')
 OPT_PARAM('query_rewrite_enabled' 'false')
 OPT_PARAM('_new_initial_join_orders' 'false')
 OPT_PARAM('optimizer_dynamic_sampling' 1)
 OPT_PARAM('optimizer_index_cost_adj' 1) */