Postgres Pro
Downloads
Home   >   mailing lists

Thread: FOREIGN KEY AND INDEXEX

FOREIGN KEY AND INDEXEX

From
"JORGE MALDONADO"
Date:
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?
 
With respect,
Jorge Maldonado
 
 

Re: FOREIGN KEY AND INDEXEX

From
Alan Hodgson
Date:
On Tuesday 28 October 2008, "JORGE MALDONADO" <jorgemal1960@gmail.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