Craig,

> Jim Starkey <jas@...> wrote:
>
> There are two problems associated with enforcing referential
> integrity. The first is whether or not the system should
> create an index on the foreign key. If the system guesses
> wrong (and it has very little to go on), and either creates
> an index with massive duplicates or fails to create an index
> when appropriate, it has created a major bottleneck. Interbase
> always creates an index for foreign keys and often suffers for
> it.

I completely agree here and would love to see a version of FB/IB
with an
option for this.


Funny, you should mention that! It is a feature for the upcoming
Firebird v1.0 release.


Sean