Re: Re-analyze Table After New Index ?

From: <purohitatul_at_gmail.com>
Date: Wed, 29 Aug 2007 23:38:53 -0000
Message-ID: <1188430733.693005.227590@i38g2000prf.googlegroups.com>

On Aug 29, 1:25 pm, "userjohn" <userj..._at_mailinator.com> wrote:
> "Mark D Powell"
>
>
>
>
>
> > Try the following experiment. Create a simple table. Populate it.
> > Create statistics on it. Now add an index and then query:
>
> > select leaf_blocks, distinct_keys,
> > AVG_LEAF_BLOCKS_PER_KEY, AVG_DATA_BLOCKS_PER_KEY
> > from dba_indexes
> > where index_name = 'Your index'
>
> > On 9.2.0.6 I see no statistics. On 10gR2 (using Oracle Express) I see
> > statistics.
>
> > I do believe that on create index and alter index rebuild that compute
> > statistics is now the default.
>
> > HTH -- Mark D Powell --
>
> ah good to know that thanks !- Hide quoted text -
>
> - Show quoted text -

I believe dynamic sampling is turned on in 10G whereas it was optional till 9iR2.
That could have caused automated stats gathering on the index in 10G

-Atul Received on Wed Aug 29 2007 - 18:38:53 CDT