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 best answer.)
A.
It influences the optimizer to use full table scans instead of index scans as the estimated cost of full table
scan is reduced.
B.
It influences the optimizer to use bitmap indexes as the estimated cost of conversion from bitmap to rowid is
reduced.
C.
It influences the optimizer to always use fast full index scans as the estimated cost of using an index is
reduced.
D.
It influences the optimizer to use indexes instead of full table scans as the estimated cost of using an index
is reduced.
Explanation:
http://www.dba-oracle.com/oracle_tips_cost_adj.htm