Re: Foreign key - index

From: Josh Kupershmidt <schmiddy(at)gmail(dot)com>
To: Majid Azimi <majid(dot)merkava(at)gmail(dot)com>
Cc: PostgreSQL - Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Foreign key - index
Date: 2010-12-25 21:34:04
Message-ID: AANLkTinQPWk=N_TY2Vfjosm8bJLSoOhN0QpVsU3O447s@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Sat, Dec 25, 2010 at 12:33 PM, Majid Azimi <majid(dot)merkava(at)gmail(dot)com> wrote:
> hi guys.
>
> Does adding a foriegn key, create an implicit index like adding unique and
> primary keys? or we should do it manually.

Creating a foreign key constraint will not create any additional
indexes on either the target table or the referencing table.

Josh

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Mladen Gogala 2010-12-26 04:28:49 Re: Foreign key - index
Previous Message Josh Kupershmidt 2010-12-25 20:48:20 Fwd: pgstatspack version?