Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: 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
No, wouldn't make any difference. If you do a select without a whereclause, Oracle has to performe a full-table-scan, so the indexes are not used. Received on Thu Jun 26 2003 - 09:30:03 CDT