Re: select ... where <column>='' does a seqscan [auf Viren geprueft]

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Silvio Matthes <silvio(dot)matthes(at)xcom(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: select ... where <column>='' does a seqscan [auf Viren geprueft]
Date: 2004-08-24 13:04:40
Message-ID: 200408241504.40569.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Am Dienstag, 24. August 2004 11:59 schrieb Silvio Matthes:
> So using the index does need more time than a sequential scan?

It's possible. If you want to prove the opposite, please post the output of
EXPLAIN ANALYZE in both cases.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Eduardo S. Fontanetti 2004-08-24 13:40:32 Dump and Restore
Previous Message Jerry Sievers 2004-08-24 12:23:14 Re: Possible to insert quoted null value into integer field?