Re: function-based index for SUM(field) and GROUP BY

Since you don't have any predicates in the WHERE clause, a FBI will not help you. Your best bet is probably Nuno's suggestion of a MV.

HTH,
Brian

porschberg wrote:
>
> I have a SQL-Statement which looks like:
> SELECT A, B, SUM(C), SUM(D)
> FROM MYTABLE
> GROUP BY A, B
> Is it possible to enhance the performance by creating a
> function-based index say
>
> CREATE INDEX BLA ON MYTABLE
> (SUM(C),SUM(D) GROUP BY A, B)
> TABLESPACE IND ...
>
> curious Thomas

-- 
===================================================================

Brian Peasland
oracle_dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"