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

From: Michael Glaesemann <grzm(at)seespotcode(dot)net>
To: Michael Glaesemann <grzm(at)seespotcode(dot)net>
Cc: "David Monarchi" <david(dot)e(dot)monarchi(at)gmail(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: Implicit btree index from unique constraint versus explicit btree index
Date: 2007-10-02 23:21:25
Message-ID: 34086A04-528D-4518-86D6-8FE92A439595@seespotcode.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


On Oct 2, 2007, at 18:01 , Michael Glaesemann wrote:

>
> 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.

And its destruction, if the table it indexes is dropped

Michael Glaesemann
grzm seespotcode net

PS ...and the lamp, and that's all that's implicit.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Tore Lukashaugen 2007-10-03 18:01:57 Simple sql question
Previous Message Michael Glaesemann 2007-10-02 23:01:44 Re: Implicit btree index from unique constraint versus explicit btree index