INDEX PROBLEMS ?

From: PostgreSQL Server <postgres(at)rsd(dot)it>
To: pgsql-sql(at)postgresql(dot)org
Subject: INDEX PROBLEMS ?
Date: 2002-11-16 18:04:32
Message-ID: Pine.LNX.4.44.0211161901570.8254-100000@sunrise2.radiostudiodelta.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


On postgres 7.2.3 I have found what follows:

explain select * from documents where iddoc>1;

Seq Scan on lotti (cost=0.00..831.79 rows=26783 width=98)

EXPLAIN
explain select * from documents where iddoc=1;

Index Scan using lotti_pkey on lotti (cost=0.00..2.26 rows=1 width=98)

Why index is not used for operators > and < ????

Alex

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2002-11-16 18:42:08 Re: DATE TIME INDEX ?
Previous Message PostgreSQL Server 2002-11-16 17:01:02 DATE TIME INDEX ?