Re: Interpreting cost on EXPLAIN PLAN

From: <artmt_at_hotmail.com>
Date: 16 Aug 2005 13:23:48 -0700
Message-ID: <1124223828.580322.5440@g14g2000cwa.googlegroups.com>

> Which version of Oracle, and do you have
> a list of optimizer related parameters which
> are not set to their default values.
>
>
> --
> Regards
>
> Jonathan Lewis
>
> Now waiting on the publishers: Cost Based Oracle - Volume 1
>
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
> The Co-operative Oracle Users' FAQ
>
> http://www.jlcomp.demon.co.uk/appearances.html
> Public Appearances - schedule updated 8th July 2005

Running Oracle 9.2.0

The only non-default optimizer parameters are: optimizer_mode CHOOSE
optimizer_index_cost_adj 10

Thanks. Received on Tue Aug 16 2005 - 15:23:48 CDT