Re: FOREIGN KEY AND INDEXEX

On Tuesday 28 October 2008, "JORGE MALDONADO"  
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