Skip site navigation (1) Skip section navigation (2)

Re: Test performance

From: "Damien Griessinger" <dgriessinger(at)free(dot)fr>
To: <pgsql-fr-generale(at)postgresql(dot)org>
Subject: Re: Test performance
Date: 2005-12-06 17:04:42
Message-ID: E1EjgE1-00020v-Ot@corwin.easynet.fr (view raw or flat)
Thread:
Lists: pgsql-fr-generale
>Par contre je me pose une question toute simple ... une clé primaire dans
>un table est forcément indexée ? ou faut-il créer  un index sur la clé ?

Les clefs primaires et étrangères engendrent automatiquement la création
d'un index :

PostgreSQL automatically creates an index for each unique constraint and
primary key constraint to enforce uniqueness. Thus, it is not necessary to
create an index explicitly for primary key columns.
http://www.postgresql.org/docs/8.1/static/sql-createtable.html#SQL-CREATETAB
LE-NOTES





Damien Griessinger





In response to

pgsql-fr-generale by date

Next:From: Francis LeboutteDate: 2005-12-06 17:07:20
Subject: Re: RE [EXTERNE]Re: Test performance.
Previous:From: Pascal SERENTDate: 2005-12-06 16:46:19
Subject: RE [EXTERNE]Re: Test performance.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group