Re: [BUGS] seq scan on a table whereas an index exist

2001-03-07 Thread Tom Lane
Nicolas GIMMILLARO <[EMAIL PROTECTED]> writes: > What's wrong with my "select * from web_access where date between > '01/01/2001' and '06/03/2001' " query ? Nothing. The planner is estimating that this query will retrieve a sufficiently large fraction of the rows in the table that a seqscan wil

[BUGS] seq scan on a table whereas an index exist

2001-03-07 Thread Nicolas GIMMILLARO
I don't understand the query plan used to resolve this query : select * from web_access where date between '01/01/2001' and '06/03/2001' The web_access table as this structure : Table "web_access" Attribute | Type | Modifier ---+--+-- source| va