Re: Adding Indexes drastically slows down App

E Elliott wrote:
> We are seeing drastic slowdowns in our system after adding 2 indexes
> to the largest table in our DB.
>

 [...]
>
> We just can't figure out why adding the 2 new indexes to an existing
> DB would cause SO much slow down - even after we did exp/imp to get
> rid of fragmentation. I know there will be some slow down with new
> indexes, but this seems extreme.
>

Hello Elizabeth,
have you tried to analyze the table after adding the indexes? I experienced similar performance impacts after mofifying a table in this way. The CBO seems to get on the wrong way very quickly.

[...]

> We're testing on: Oracle 8.1.6 on NT.
>
>

Hope that helps,
Lothar

-- 
Lothar Armbrüster       | la_at_oktagramm.de
Hauptstr. 26            | la_at_heptagramm.de
D-65346 Eltville        | lothar.armbruester_at_t-online.de