Re: Index becomes slower over the day

From: Greg Rahn <greg_at_structureddata.org>
Date: Wed, 14 Jan 2009 00:00:36 -0800
Message-ID: <a9c093440901140000j6564cdc1v32e9aca54ceddde3_at_mail.gmail.com>

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

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