RE: Should we stop analyzing?

From: Josh Collier <Josh.Collier_at_Banfield.net>
Date: Tue, 30 Dec 2003 09:49:33 -0800
Message-ID: <F001.005DB46A.20031230094933@fatcity.com>

Is there an easy way to track the rate of change in a particular table?

-----Original Message-----
Sent: Tuesday, December 30, 2003 7:24 AM To: Multiple recipients of list ORACLE-L

Makes sense, BUT...
"If the data changes A LOT you should of course re-analyze." is assuming you know when that happens. You are assuming communication between users, developers, and DBAs. Communication is my New Year's Resolution.

I would at least suggest exporting stats before changing them. Then there are all the extra problems such as retaining histograms with 8i, applications which constantly insert/delete from temporary tables (not Oracle temp tables), ...

Henry

-----Original Message-----

>>But then I listened to Dave Ensor at the UKOUG conference, and he said roughly this:

Stop analyzing after the first analyze. It's the new stats that cause the optimizer to change execution plans.
"I know that big tables tend to stay big. Small tables stay small. Unique indexes stay unique and non-unique indexes stay non-unique..."
If the data changes A LOT you should of course re-analyze.

Mogens
<<

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: mln_at_miracleas.dk

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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Poras, Henry R.
INET: Henry_Poras_at_dfci.harvard.edu

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------