Re: Seq Scans when index expected to be used - Mailing list pgsql-sql

jasiek wrote:
> On Sat, 29 Nov 2003 08:49:24 -0800 (PST), ow wrote
> 
>>explain select b, c, a
>>from test
>>group by b, c, a
>>having count(*) > 1

Why would you expect this to use an index scan when it needs to read the 
entire table? If you read the whole table (or even a significant 
fraction of it), a seq scan is faster.

Joe