Re: Not analyzing tables with nearly fixed size?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 2 Jun 2004 15:16:02 +0000 (UTC)
Message-ID: <c9kqvi$9a6$1@sparta.btinternet.com>

There is no correct answer to that question.

For example, if one of the columns is sequence based, than the cycle of delete/insert will keep increasing the low and high values of that column. If that column is used frequently in a range-based predicate, then you need to keep its statistics up to date.

Most columns, though, may simply be recycling the same volume of the same ranges of data. In which case they don't need new statistics.

-- 
Regards

Jonathan Lewis

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

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

http://www.jlcomp.demon.co.uk/seminar.html
Optimising Oracle Seminar - schedule updated May 1st


"Holger Marzen" <holger_at_marzen.de> wrote in message
news:c9kmts$uov$1_at_bluebell.marzen.de...


> Given a table where new data is inserted and old data is purged

> periodically.

>

> Is it wise to gather stats frequently or is it ok to save the cpu cycles

> and analyze only once, when the table's got its final size?

Received on Wed Jun 02 2004 - 10:16:02 CDT