Re: Implicit btree index from unique constraint versus explicit btree index

From: Michael Glaesemann <grzm(at)seespotcode(dot)net>
To: "David Monarchi" <david(dot)e(dot)monarchi(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Implicit btree index from unique constraint versus explicit btree index
Date: 2007-10-02 23:01:44
Message-ID: C8472D89-692E-463E-B1BE-D7B417132C0A@seespotcode.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


On Oct 2, 2007, at 17:34 , David Monarchi wrote:

> Does PG use this implicit index in answering queries in the same
> manner as an explicit index,

Yes. The only thing implicit about the index is its creation.

Michael Glaesemann
grzm seespotcode net

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Michael Glaesemann 2007-10-02 23:21:25 Re: Implicit btree index from unique constraint versus explicit btree index
Previous Message David Monarchi 2007-10-02 22:34:39 Implicit btree index from unique constraint versus explicit btree index