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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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