Hints

OPT_PARAM Hint in oracle

The OPT_PARAM hint in oracle lets you set an initialization parameter for the duration of the current query only. As per oracle documentation following parameters supports with OPT_PARAM hint. OPTIMIZER_DYNAMIC_SAMPLING OPTIMIZER_INDEX_CACHING OPTIMIZER_INDEX_COST_ADJ OPTIMIZER_SECURE_VIEW_MERGING STAR_TRANSFORMATION_ENABLED