No, but a materialized view comes to mind... ;)
--
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam
"porschberg" <thomas.porschberg_at_osp-dd.de> wrote in message
news:8d9566f5.0306260407.1839c5a6_at_posting.google.com...
> 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
Received on Thu Jun 26 2003 - 07:42:23 CDT
