Re: Where are these table stats coming from?

What about the other table statistics - blocks and avg_rowlen? Are those 
filled in by the "compute statistics" of the alter index rebuild?

Barbara Baker wrote:
> OpenVMS 7.3-1  Oracle 9.2.0.4
> 
> Seems like a dumb question, but . . . .  I don't understand what's
> generating the stats on my table.
> 
> At the end of the index rebuild command, the table DOES have
> statistics.  And the time of the statistics is identical to the
> creation of the last index.
> 
> TABLE_NAME         NUM_ROWS      LAST_ANALYZED
> ------------------------------ ----------               -------------------=
> -
> WO                         16233354          08-JUN-2005 04:47:05
> 
> Why does rebuilding indexes/computing statistics cause table
> statistics to be generated?
> Do you think it computes statistics for the table for each "alter
> index" command?  (I wasn't up at 4:47 this morning to check it out)
> If so, is there a way to turn it off?
> 

-- 
Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com
--
http://www.freelists.org/webpage/oracle-l

Other related posts: