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

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 (view raw or flat)
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

pgsql-novice by date

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

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