On Tue, Mar 8, 2011 at 10:42 AM, Igor Neyman <ineyman(at)perceptron(dot)com> wrote:
> Indexes don't "maintain counts", indexes maintain pointers to the table
> records.
>
The whole point is that they don't, even if you can afford the costs.
What you need is "materialized view" storing aggregates.
> And it looks like you already have it with your triggers.
>
With cumbersome, awkward triggers, yes.
--
Glenn Maynard