Indices for foreign keys

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:

"JM" == Jeff Martin <jeff@dgjc.org> writes:

JM> Are indices automatically created for foreign keys?

JM> Thanks for any help,

Empirical evidence suggests no; if it is not documented, submit a
change request for the docs.

Also, don't post HTML. Thanks.