> I guess what I"m really asking is why can't you run aggregates over an index?
It's got to do with MVCC and transaction consistency. Running count(*) or an aggregate function on an index could include records that should not be visible to your current transaction. -- Scott Ribe [EMAIL PROTECTED] http://www.killerbytes.com/ (303) 665-7007 voice ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
