Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> function-based index for SUM(field) and GROUP BY
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:07:51 CDT