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