Optimizer parameters……

optimizer_index_caching indicates the percentage of index blocks that WILL be cached;
optimizer_index_cost_adj indicates the percentage of table blocks that will NOT be cached.

Of course, optimizer_index_caching applies only to branch blocks and only for nested loop joins and in list iterators and, at the end of the day, it’s just a number for which we invent a meaning.

ref: http://jonathanlewis.wordpress.com/2006/10/24/optimizer_index_cost_adj/

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s