Re: Re-analyze Table After New Index ?

From: userjohn <userjohn_at_mailinator.com>
Date: Wed, 29 Aug 2007 16:25:53 -0400
Message-ID: <13dblkk2d4pj1de@corp.supernews.com>

"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 ! Received on Wed Aug 29 2007 - 15:25:53 CDT