Am Thursday, 14. August 2008 schrieb Dmitry Teslenko: > SELECT SUM(...) FROM table1 WHERE field3 = 'ABC' AND field1 <> 1 > GROUP BY field2 > > And planner picks up a sequential scan of a table. Why does he? Presumably because it thinks it is the best plan, and I see no reason to doubt that outright. You might get better performance with an index on field3.
