Re: Adding Indexes drastically slows down App

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

 [snip]
>
>I would appreciate any insight or other things to try. Let me know if
>I need to post any additional info.

Look at how the index modifies the execution plans of the long-running queries.

-- 
Andrew Mobbs - http://www.chiark.greenend.org.uk/~andrewm/