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

On Oct 2, 2007, at 18:01 , Michael Glaesemann wrote:

>
> 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.

And its destruction, if the table it indexes is dropped

Michael Glaesemann
grzm seespotcode net

PS ...and the lamp, and that's all that's implicit.