Multiple choice technology performance

This parameter lets you tune optimizer behavior for access path selection to be more or less index friendly, that is, to make the optimizer more or less prone to selecting an index access path over a full table scan. The default makes full table scan and index use equal.

  1. Optimizer Index Caching

  2. Optimizer Index Cost Adjustments

  3. Optimizer Mode

  4. Parallel Automatic Tuning
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Optimizer Index Cost Adjustments (OPTIMIZER_INDEX_COST_ADJ) parameter adjusts the cost of index access paths relative to full table scans. A value less than 100 makes indexes cheaper, encouraging index use; greater than 100 makes full table scans more attractive. The default of 100 treats them equally.

Keep practicing — related questions