Re: Index becomes slower over the day

From: Greg Rahn <>
Date: Wed, 14 Jan 2009 00:00:36 -0800
Message-ID: <>

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 <> 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!

Greg Rahn
Received on Wed Jan 14 2009 - 02:00:36 CST

Original text of this message