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

• Re: INDEX BUG??? at 2001-09-03 17:43:06 from Stephan Szabo
• Re: INDEX BUG??? at 2001-09-03 17:57:37 from Peter Eisentraut

pgsql-hackers by date

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