Re: 2 million row database from hell! help a newbie in over his head.

Mikito,

> more relational) solution would be using index. I'm not sure if built-in
 indexes
> for "group by" are readily available yet off the shelf, but with extending
> indexing feature you can certainly program one.

You've lost me, here. I guess I've never worked on an RDBMS where an appropriate index would NOT
be used by the optimizer to implement "group by". As far as I can tell, Oracle uses an index on the group by column with both RBO and CBO.

And I'm sure that the index is used with Oracle Rdb (not to be confused with Oracle RDBMS).

What environment are you discussing where you have to "program your own" index?

--
Regards,
    David Cressey
    www.dcressey.com