Postgres Pro
Downloads
Home   >   mailing lists

Re: Implicit btree index from unique constraint versus explicit btree index - Mailing list pgsql-novice

From Michael Glaesemann
Subject Re: Implicit btree index from unique constraint versus explicit btree index
Date
Msg-id C8472D89-692E-463E-B1BE-D7B417132C0A@seespotcode.net
Whole thread Raw
In response to Implicit btree index from unique constraint versus explicit btree index  ("David Monarchi" <david.e.monarchi@gmail.com>)
Responses Re: Implicit btree index from unique constraint versus explicit btree index  (Michael Glaesemann <grzm@seespotcode.net>)
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: "David Monarchi"
Date:
Subject: Implicit btree index from unique constraint versus explicit btree index
Next
From: Michael Glaesemann
Date:
Subject: Re: Implicit btree index from unique constraint versus explicit btree index