Skip site navigation (1) Skip section navigation (2)

INDEX BUG???

From: "gabriel" <gabriel(at)workingnetsp(dot)com(dot)br>
To: pgsql-hackers(at)postgresql(dot)org
Subject: INDEX BUG???
Date: 2001-09-03 13:08:40
Message-ID: 20010903130840.21272.qmail@hm36.locaweb.com.br (view raw or flat)
Thread:
Lists: pgsql-hackers
hello All

I tried the following commands:
ponto=# explain select * from horarios where funcionario>10000;
NOTICE:  QUERY PLAN:

Seq Scan on horarios  (cost=0.00..176.21 rows=2432 width=132)

EXPLAIN
ponto=# explain select * from horarios where funcionario=10000;
NOTICE:  QUERY PLAN:

Index Scan using horarios_func_data on horarios  (cost=0.00..55.37 rows=73 
width=132)

EXPLAIN

So my question is why in the first case the postgre did'nt use the index 
and made a seq scan ??

thanks and sorry about my english...

Responses

pgsql-hackers by date

Next:From: Marc G. FournierDate: 2001-09-03 15:46:29
Subject: ignore ...
Previous:From: Henshall, Stuart - WCPDate: 2001-09-03 09:03:55
Subject: Re: Porting to Native WindowsNT/2000

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group