|
 |
|
Oracle hidden SQL subquery parameters
Don Burleson
|
Note: Oracle hidden parameters are undocumented
and unsupported by Oracle.
Make sure that you thoroughly test all hidden parameters before
placing them in your production environment.
Parameter Name Description
----------------------------------------- ----------------------------------------------------------------
_subquery_pruning_cost_factor subquery pruning cost factor
_subquery_pruning_enabled enable the use of subquery predicates to perform pruning
_subquery_pruning_mv_enabled enable the use of subquery predicates with MVs to perform prunin
_subquery_pruning_reduction subquery pruning reduction factor
|
