Re: all foreign key should have index?

Tony Rogerson wrote:

> > No. But better SQL products construct a "PK=FK" index under the
> > covers for you.
>
> Do you have a list of those?

MySQL for one.

> Is it configurable? I'm not sure I want my rdbms generating a 5GB index on my foreign key when I
> might not require it.

The indexes are usually created to aid in the Cascading or Restricting of deletes and updates.

Regards,

Murdoc
--

.

Relevant Pages