Re: Index becomes slower over the day
Date: Wed, 14 Jan 2009 00:00:36 -0800
Can you provide a bit more detail?
- definition of the index (ddl)
- what "using" means and what "case" you are referring to (what plans you are referencing)
- some detail of the data/keys that are participating in the index (random, increasing values, etc)
- version of database
- is the workload insert only? or some deletes or updates?
On Tue, Jan 13, 2009 at 11:49 PM, Martin Klier <usn_at_usn-it.de> wrote:
> Dear list,
> I've got the situation, that using one particular index is fast and
> becomes slower. In detail, the index becomes slower over the day/week,
> and since it's an OLTP system, this is annoying. (CPU and IO cost are
> high). The index always stays "VALID".
> Rebuilding it immediately speeds up the whole case by factors of ten,
> without any change in the execution plan before or after. But I can't
> rebuild it on an hourly basis, of course!
-- Regards, Greg Rahn http://structureddata.org -- http://www.freelists.org/webpage/oracle-lReceived on Wed Jan 14 2009 - 02:00:36 CST