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

Search Discussions

Discussion Posts

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 1 of 3 | next ›
Discussion Overview
grouppgsql-novice @
categoriespostgresql
postedOct 2, '07 at 10:34p
activeOct 2, '07 at 11:21p
posts3
users2
websitepostgresql.org
irc#postgresql

People

Translate

site design / logo © 2022 Grokbase