FOREIGN KEY AND INDEXEX - Mailing list pgsql-novice

From JORGE MALDONADO
Subject FOREIGN KEY AND INDEXEX
Date
Msg-id f03943a00810281304r3e6340a8qa1669047d87d1640@mail.gmail.com
Whole thread Raw
Responses Re: FOREIGN KEY AND INDEXEX  (Alan Hodgson <ahodgson@simkin.ca>)
List pgsql-novice
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
 
 

pgsql-novice by date:

Previous
From: Marcin Krol
Date:
Subject: Re: why is index not used?
Next
From: Alan Hodgson
Date:
Subject: Re: FOREIGN KEY AND INDEXEX