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