I think no.
The foreign key constraint implies a trigger that enforces the
relationship between the tables but no index is created. You'll have to
create it yourself.
Bye
--
Ing. Denis Gasparin: denis@edistar.com
---------------------------
Programmer & System Administrator - Edistar srl
Il sab, 2002-02-02 alle 23:04, Jeff Martin ha scritto:
> Are indices automatically created for foreign keys?
>
> Thanks for any help,
>
> Jeff
> Jeff Martin
> 704 Torrey Lane, Apartment D
> Boalsburg, PA 16827
> H814-466-7791
> jeff@dgjc.org
> www.dgjc.org
>
>
>