Is there a way to create an index that would make this query be efficient and not perform a sequential scan?
SELECT count(*) AS count,id FROM sometable GROUP BY id; .. I've considered creating a rule on this table which would put the results of this into another table anytime it is updated, but I thought there might be an easier way. Thanks! - Greg ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
