Subject Re: [Firebird-Architect] Foreign keys and Indexes
Author Ann Harrison
pascsam wrote:

>I understand that Firebird always creates an index on the "child" table for
>a foreign key.
Yes it does and in many cases - far from most, but many - the index
creates problems. Unfortunately, several parts of the engine are
"aware" that there is an index where there is a foreign key. As a
result, making indexes optional on foreign key child fields is going to
be complex.