Re: stats document links.
From: Greg Rahn <greg_at_structureddata.org>
Date: Tue, 22 Mar 2011 21:18:56 -0700
Message-ID: <AANLkTino62jZSebTS_NWWffOyUtrfdRZ5XVwX9wgRy-M_at_mail.gmail.com>
If the data has not changed or significantly changed, then there is no reason to regather unless one wants to appear productive and burn up system resources :)
http://structureddata.org/2008/03/26/choosing-an-optimal-stats-gathering-strategy/
Date: Tue, 22 Mar 2011 21:18:56 -0700
Message-ID: <AANLkTino62jZSebTS_NWWffOyUtrfdRZ5XVwX9wgRy-M_at_mail.gmail.com>
If the data has not changed or significantly changed, then there is no reason to regather unless one wants to appear productive and burn up system resources :)
http://structureddata.org/2008/03/26/choosing-an-optimal-stats-gathering-strategy/
On Tue, Mar 22, 2011 at 10:18 AM, <Joel.Patterson_at_crowley.com> wrote:
> I use default stats collection method on 10.2.0.4 database. I get
> questioned (via email) about someones attention being drawn to the fact that
> many tables have not had stats collected in months, and some have had them
> recently.
>
> Does anyone off hand have some nice links I an send these people, I believe
> this last on is a project manager type.
-- Regards, Greg Rahn http://structureddata.org -- http://www.freelists.org/webpage/oracle-lReceived on Tue Mar 22 2011 - 23:18:56 CDT