Re: Stale statistic

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Mon, 23 Jan 2006 07:04:29 -0700
Message-ID: <43D4E26D.2040402@centrexcc.com>

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
--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jan 23 2006 - 08:04:29 CST