Subject Re: [firebird-support] What role indexes has in Firebird?
Author Aage Johansen
jasajona wrote:
> I found that in one table I have dublicated indexes. There is indexes
> created by foreign key and another indexes that I created on the same
> foreign key fields. I removed these unuseful indexes.
> After some days I found out that some of my query execution never
> ends. I allmost killed my self trying to find what is wrong.
> Finally I added these dublicated indexes back and querys started to
> execute in several seconds.
> Can anyone explain why this happend? Why firebird is not using foreign
> key indexes?

You will have to be more specific. Do post metadata, actual query and the
plan. Then, maybe someone can help.

Aage J.