On Tue, Mar 8, 2011 at 10:42 AM, Igor Neyman <iney...@perceptron.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

Reply via email to