Re: foreign key

David Turner wrote:
>
> Does anyone know whether an index is created when you
> create a foreign key. I was under the impression that an
> index was created for a primary key but am unclear whether an
> index is created for a foreign and/or a unique key.
>
> Any help is appreciated, David T
No.
The index, if required (and it usually is), must be created manually on the referring key.
It is, of course, necessary that an index already exist on the referred-to primary (or other unique) key.

Chrysalis. Received on Sat May 10 1997 - 00:00:00 CDT