Postgres Pro
Downloads
Home   >   mailing lists

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

From David Monarchi
Subject Implicit btree index from unique constraint versus explicit btree index
Date
Msg-id eea51fdb0710021534m477060f9g5352da717c477a4e@mail.gmail.com
Whole thread Raw
Responses Re: Implicit btree index from unique constraint versus explicit btree index  (Michael Glaesemann <grzm@seespotcode.net>)
List pgsql-novice
Tree view
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

pgsql-novice by date:

Previous
From: "Wright, George"
Date:
Subject: Re: DST question
Next
From: Michael Glaesemann
Date:
Subject: Re: Implicit btree index from unique constraint versus explicit btree index