Examine the command to change a parameter value from the default to 50: SQL> ALTER SYSTEM SET OPTIMIZER_INDEX_COST_ADJ = 50; What is the effect of changing the value of the parameter? (Choose the…

Question

Options

• AIt influences the optimizer to use full table scans instead of index scans as the estimated cost of
• BIt influences the optimizer to use bitmap indexes as the estimated cost of conversion from bitmap
• CIt influences the optimizer to always use fast full index scans as the estimated cost of using an
• DIt influences the optimizer to use indexes instead of full table scans as the estimated cost of using

• A
  73% (33)
• B
  7% (3)
• C
  4% (2)
• D
  16% (7)

No community discussion yet for this question.