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

Implicit btree index from unique constraint versus explicit btree index

From: "David Monarchi" <david(dot)e(dot)monarchi(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Implicit btree index from unique constraint versus explicit btree index
Date: 2007-10-02 22:34:39
Message-ID: eea51fdb0710021534m477060f9g5352da717c477a4e@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hello -

PG v8.2

I have a number of fields in tables with a unique constraint defined on them
resulting in the creation of an implicit btree index on the field.

Does PG use this implicit index in answering queries in the same manner as
an explicit index, or do I have to create an explicit index in addition to
the implicit one?

Thank you.

David

Responses

pgsql-novice by date

Next:From: Michael GlaesemannDate: 2007-10-02 23:01:44
Subject: Re: Implicit btree index from unique constraint versus explicit btree index
Previous:From: Wright, GeorgeDate: 2007-10-02 14:25:30
Subject: Re: DST question

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