Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OPTIMIZER_INDEX_COST_ADJ

845641Apr 24 2012 — edited Jun 7 2012

Firstly i am in 10G R2 on rhel5, Well frankly speaking about the parameter OPTIMIZER_INDEX_COST_ADJ, that more value i keep more optimizer will think that it will be expensive to go for an index scan..Range of values i saw in oracle doc 1 to 10000 default value 100 ... Default value oracle says oracle will evaluate at regular cost, i mean the cost of index access paths.. So my question is simple .. is it applicable for all index scans like index unique scan , index range scans, index fast full scan and so on ...

Regards
Satyajeet

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 5 2012

Added on Apr 24 2012

#general-database-discussions

12 comments

2,033 views