Re: Where are these table stats coming from?
- From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
- To: barb.baker@xxxxxxxxx
- Date: Wed, 08 Jun 2005 09:10:16 -0600
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
