Subject RE: [ib-support] Is a joined query faster than a subquery, or doe sn't it matter?
Author Leyne, Sean

Strictly speaking foreign-keys do not need to be indices. The values
must be constrained to ensure that data integrity is maintained but
indexes are not required.

With IB v4.x (I think) it was decided that indexes would be
automatically created for foreign keys - to improve the performance of
cascade delete/update operations. However, it has been reasonably
suggested that this feature should be "disabled" since it can result in
very poorly structured indexes (typically they have a very low
selectivity - few values for a lot of rows) which significantly decrease
the performance of SELECTs and other common system operations.

-----Original Message-----
From: guido.klapperich@...
Sent: Wednesday, February 14, 2001 11:30 AM
Subject: Re: [ib-support] Is a joined query faster than a
subquery, or doesn't it matter?

> I read somewhere that Interbase creates an index automatic for
> foreign and unique keys.

Primary and Foreign-Keys ARE indices.


To unsubscribe from this group, send an email to: