Re: Index Statistics not gathered even after runing dbms_stats.GATHER_TABLE_STATS
Date: Thu, 24 Dec 2009 10:13:47 +0100
It should gather it if you tell it to. There is a parameter for cascade, have you tried using it? If not, add it to your parameter list (cascade => true)
On Thu, Dec 24, 2009 at 9:31 AM, Dwaraknath Krishnamurthi < dwarak.k_at_gmail.com> wrote:
> Hi All,
> I am trying to collect statistics to a table 'T' which is owned by 'S'
> When i try to gather statistics to the table, I see that the table
> statistics are gathered but the index statistics are still not gathered.
> I use the following command to collect the statistics.
> EXEC DBMS_STATS.GATHER_TABLE_STATS('S', 'T',estimate_percent => 30);
> I confirmed the statics of index are not gathered by quering
> select * from dba_indexes
> where table_name = 'T'
> columns leaf_blocks ,distinct_keys,clustering_factor,num_rows shows value
> and the last_analyzed does not show the date on which i ran the
> Why does DBMS_STATS.GATHER_TABLE_STATS not gather statistics for the index?
> I have not tried running gather_index_stats or rebuilding the index.