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" <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
