Subject RE: [ib-support] Table size and indexing
Author Leyne, Sean
Ann,

> -----Original Message-----
> From: Ann W. Harrison [mailto:aharrison@...]
> Sent: Monday, June 18, 2001 8:57 PM

<snip>

>
> At the moment, you can not delete the index that is automatically
> created on Beta.AlphaIdent as part of the foreign key declaration.
> The only solution is to use triggers rather than foreign keys to
> enforce consistency in such cases.
>

Does the fact that with the latest Firebird snapshot build you can
deactivate the FK indexes, help in this case?


Sean