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.

cheers,
Helen

All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org ·
http://users.tpg.com.au/helebor/
_______________________________________________________