Note:272202.1


ALTER SESSION SET "_SORT_ELIMINATION_COST_RATIO"=5.

-- The above statement directs the CBO to consider a plan with ORDER BY sort elimination as long as the plan is no more expensive than 5 times the cost of the best known plan (that uses sort).

-- The parameter can be set to any non-negative integer.

Thanks folks