The initialization parameter OPTIMIZER_INDEX_COST_ADJ has a certain popularity in the area of Oracle Database Performance Tuning. Especially, it can be used to make the Optimizer favor index access instead of full table scans. But that is not necessarily appropriate – in fact it can have very counterproductive effects on performance. Richard Foote has some very instructive postings about this, especially this one is impressive, in my view.
#1 von bernardino am August 26, 2014 - 23:26
#2 von Nassou am August 23, 2016 - 17:20
I agree, and especially perfectly detailed and explained with consistency.