performance of count(*)

I need to optimize queries that deal with some aggregates regarding resource availability. My specific problem is, I think, very closely analogous to select count(*)... where...

I know roughly how to do it, aggregated stats table, triggers appending to it, occasional updates to coalesce entries. I'd just like to see an example to confirm my own plan and see if I'm missing any details.

I'm sure I've seen references to articles on ways to do this, but all google is getting me is generic complaints about count(*) performance and suggestions to use stats for estimated total rows in a table, nothing useful for this.

--
Scott Ribe
scott_ribe(at)elevated-dev(dot)com
http://www.elevated-dev.com/
(303) 722-0567 voice