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?

Wolfgang Breitling
Centrex Consulting Corporation

Other related posts: