Re: Stale statistic
- From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
- To: jos1992831@xxxxxxxxxxxx
- Date: Mon, 23 Jan 2006 07:04:29 -0700
Define "stale statistics".
As far as I am concerned there are two types of statistics - those that
accurately, or adequately, describe the data in the table for the
purpose of the optimizer - and those that don't. Freshly computed
statistics can easily belong to the latter category while months or
years old statistics can just as easily belong to the former.
Jos wrote:
Hi list:
Is it possible to identify stale statistic without turning on tab
monitoring?
Regards,
Jos
--
Regards
Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com
--
//www.freelists.org/webpage/oracle-l
Other related posts: