Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> function-based index for SUM(field) and GROUP BY

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

From: porschberg <thomas.porschberg_at_osp-dd.de>
Date: 26 Jun 2003 05:07:51 -0700
Message-ID: <8d9566f5.0306260407.1839c5a6@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:07:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US