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 -> Oracle Performance

Oracle Performance

From: pbrajesh <rajesh.tamil.india_at_gmail.com>
Date: 12 Mar 2007 06:30:57 -0700
Message-ID: <1173706257.681444.29140@j27g2000cwj.googlegroups.com> 





Hi,



We have an datawarehouse database Oracle 9i.
A table has 145 fields and 70 million records for a month.
We want to perform an group by 5 of fields in the table .
How to do that will minimum time ?. I wrote an oracle procedure but it
is very slow.



Thanks


R
Received on Mon Mar 12 2007 - 08:30:57 CDT












Original text of this message













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