Subject | Re: [Firebird-Architect] Foreign keys and Indexes |
---|---|
Author | Ann Harrison |
Post date | 2003-06-26T22:05:24Z |
pascsam wrote:
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.
Regards,
Ann
>I understand that Firebird always creates an index on the "child" table forYes it does and in many cases - far from most, but many - the index
>a foreign key.
>
>
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.
Regards,
Ann