Subject Re: [ib-support] Foreign Key index optional?
Author Helen Borrie
At 10:07 PM 02-05-02 +0100, you wrote:
>There was some discussion last year on the use of foreign keys referencing
>small control tables and the fact that the foreign key's mandatory index
>would slow things down. I think it was mentioned that the foreign key's
>index would be made optional. Are foreign keys' indexes optional now?

No. It was tried and tested and turned out to have a lot of unforeseen
ramifications at ODS level; so it has been deferred for the time being.


All for Open and Open for All
Firebird Open SQL Database · ·