Requirement for using OPTIMIZER_INDEX_CACHING and OPTIMIZER_INDEX_COST_ADJ
OPTIMIZER_INDEX_CACHING
OPTIMIZER_INDEX_COST_ADJ
Qn. Whats the purpose of these two parameters. I read the documentation
'reference' guide for 10g
and from my understanding these seem to over-ride the default behaviour of how the optimizer would calculate the cost of the query. And in both above, it seems to
favour the indexing option
and thus reducing the cost.
I believe this could very well have been achieved by using
/*hints*/
if at all its really required.
Whats the explicit purpose of using / modifying the above two.
0