Re: Index getting "old" fast

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Mon, 25 Feb 2002 11:44:02 -0000
Message-ID: <3c7a2391$0$234$ed9e5944@reading.news.pipex.net>

"damorgan" <dan.morgan_at_ci.seattle.wa.us> wrote in message news:3C72A226.BA453A6_at_ci.seattle.wa.us...
> 2880 inserts are making your indexes go bad or requiring new statistics? I
don't buy it.

I do. 13 rows made our finance app go bad. Makes sense of course. 13 rows = periods for a new financial year. reanalyze worked fine. So sure in general an extra days worth of collected data won't make a significant difference but it migfht do in some situations - like there are only three days worth of data in the table to start with. So it all depends.

either way an overnight analyze is likely to do the job adequately.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************

Received on Mon Feb 25 2002 - 05:44:02 CST