Subject Re: [firebird-support] New Index causes unsuspecting queries to hang
Author Helen Borrie
At 12:41 AM 17/09/2003 +0000, you wrote:
>We have a big database with many queries. I optimized one 2 minute
>query by adding an index on an integer. The query now takes 2 to 3
>Another Query however that uses the same table now freezes when this
>new index is enabled.
>I have had this on 2 different indexing situations.
>The plan that was being used with the new index included the new
>index when it did not need it because when it was disabled it went
>Does anyone know what would cause this. It makes it impossible to
>optimize cause I might kill some other query somewhere in the system.

This is a "crystal ball" question. Provide specifics of the queries and
indexes, other indexes that this one steps on, and also say what database
and version you are using.