Re: [HACKERS] Optimizer bug??

[Gaetano Mendola]

Ismail Kizir wrote:

Hi everybody,

1 .... EXPLAIN SELECT COUNT(*) AS c FROM articletbl WHERE
      ((mydate BETWEEN '2004-04-24' AND '2004-05-24' )
)

2 .... EXPLAIN SELECT COUNT(*) AS c FROM articletbl WHERE
      ((mydate = '2004-04-24')
)

(I ran VACUUM ANALYZE before running those)

mydate is an indexed date column.
The optimizer optimizes the second query but, it doesn't optimize the first
one and decides to make a "sequential scan".
Is this a bug?
Or may someone explain me the reason?

give us the result of these queries:

SELECT COUNT(*) FROM articletbl;

SELECT COUNT(*) AS c FROM articletbl WHERE
mydate BETWEEN '2004-04-24' AND '2004-05-24';

SELECT COUNT(*) AS c FROM articletbl WHERE
mydate = '2004-04-24';

Regards
Gaetano Mendola

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])