FOREIGN KEY AND INDEXEX

From: "JORGE MALDONADO" <jorgemal1960(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: FOREIGN KEY AND INDEXEX
Date: 2008-10-28 20:04:17
Message-ID: f03943a00810281304r3e6340a8qa1669047d87d1640@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Alan Hodgson 2008-10-28 21:26:43 Re: FOREIGN KEY AND INDEXEX
Previous Message Marcin Krol 2008-10-28 18:47:58 Re: why is index not used?