Re: OPTIMIZER_INDEX_COST_ADJ & OPTIMIZER_INDEX_CACHING

nirav wrote:
> Hi,
>
> I have both of these parameters . set at their default values in my db.
> (100 & 0 respectively.) That however might not be the correct setting ,
> so could you please guide on how to decide the correct setting for
> these parameters for the database(version 9.2.0.6)?

Hi nirav,

Tom Kyte's book ("Effective Oracle by Design") has an excellent section on how you can tweak these. Dropping the first one in your subject line and increasing the second both cause the otpimizer to favor indexes...sometimes, but not always, a good thing.

Regards,

Steve Received on Fri Jun 09 2006 - 09:32:00 CDT