Re: Foreign keys and indexes - Mailing list pgsql-general

From Ragnar
Subject Re: Foreign keys and indexes
Date
Msg-id 1181050216.5953.16.camel@localhost.localdomain
Whole thread Raw
In response to Foreign keys and indexes  (Marc Compte <mcompte@sigte.udg.es>)
List pgsql-general
On þri, 2007-06-05 at 11:49 +0200, Marc Compte wrote:

> Does PostgreSQL create an implicit index also for foreign keys?

no


>  or must I create it explicitly?

if you want one, yes.

not everyone wants an index on all their foreign keys,
but they can be useful in some circumstances.

gnari



pgsql-general by date:

Previous
From: Richard Broersma Jr
Date:
Subject: Re: Foreign keys and indexes
Next
From: Michael Fuhr
Date:
Subject: Re: Foreign keys and indexes