On Tuesday 28 October 2008, "JORGE MALDONADO" <jorgemal1960(at)gmail(dot)com>
wrote:
> I need to define an index for a table but such an index already exists as
> a foreign key.
> I have fk_state (a foreign key) and I need a common index (ix_state).
> Should I define the index or does the foreign key work like an index too?
You need the index. Primary keys and unique constraints are implemented as
indexes, but not foreign keys.
--
Alan