Re: Should we stop analyzing?

It's just like index rebuilding.

Too many people do it too aggressively, too often and waste their time and the machine resources doing it for very little benefit. But if you have the time and resources, then it doesn't often do too much damage.

However, there are cases where you really do need to get some statistics up to date - particularly for columns like timestamps or sequences that are always increasing in value.

NOTE -
    up to date = correct for the current moment in time     fresh = recently acquired

To quote one of the people at the UKOUG conference:

    "The statistics on the US_STATES table aren't     fresh, because I gathered them 5 years ago but     they are up to date, because the number, names,     and abbreviations for the states haven't changed     recently".

Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

  The educated person is not the person
  who can answer the questions, but the
  person who can question the answers -- T. Schick Jr

One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html

Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html ____UK___November

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, December 30, 2003 10:34 AM

>
> Friends,
>
> I'd like to start a debate, which perhaps has already taken place, but
> if so I don't recall it: Should we stop analyzing tables and indexes?
>
> Let me clarify:
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Lewis
  INET: jonathan_at_jlcomp.demon.co.uk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).